johanrex

WITH   cte
AS     (SELECT 
			1 AS n -- anchor member
			,Cast(Cast(CRYPT_GEN_RANDOM(4) as INT) as Float) AS rnd
        UNION ALL
        SELECT 
			n + 1 -- recursive member
			,Cast(Cast(CRYPT_GEN_RANDOM(4) as INT) as Float)
        FROM   cte

johanrex

DECLARE @nrRows INT;
SET @nrRows=1000000;

--drop table if exists tmp;
create table tmp
(
	idString varchar(36)
);