Different rand result for each row

SELECT 
    Q.ID AS QID,
    Q.Batch AS Q_B,
    B.[order] AS B_O,
    B.comments AS B_C,
    ET.Description AS ETD,
    ET.ID AS ETI,
    Br.Brand AS BRB,
    Br.ID AS BRI,
    Q.ReceiveDate AS QRD,
    CAST(FLOOR(REVERSE(RAND(B.[order]))) AS INT) AS RS_ID
INTO
    #TMP
FROM 
    QA Q
LEFT JOIN
    Batch B
    ON B.QAID=Q.ID 
LEFT JOIN
    QAErrors QE
    ON QE.ID=B.QEID 
LEFT JOIN
    ErrorTypes ET
    ON ET.ID=QE.ErrorTypeID
LEFT JOIN
    Brands Br
    ON Br.ID=Q.BrandID
WHERE
    KeyDate
        BETWEEN
            @mindate
        AND
            @maxdate;

IF ET.ID is not null
BEGIN
     CAST(FLOOR(REVERSE(RAND(B.[order]+CAST(ET.ID AS REAL)))) AS INT) AS RS_ID
END
ELSE
BEGIN
     CAST(FLOOR(REVERSE(RAND(B.[order]))) AS INT) AS RS_ID
END

SELECT
*
FROM
WHEREVER
ORDER BY
NewID();

SELECT
NewID(),
*
FROM
WHEREVER;