create table RandomNumbers (
ID int primary key,
Number int)
go
;with 
CTE1 (Number) as
	(select abs(checksum(newid()))/100
	from common.dbo.bignumbers bn1,
	common.dbo.bignumbers bn2),
CTE2 (Number) as
	(select distinct number
	from cte1)
insert into dbo.randomnumbers (id, number)
select row_number() over (order by newid()), number
from cte2

 SELECT N,COUNT(*)
   FROM (SELECT TOP 1000000
                CHECKSUM(NEWID()) AS N
           FROM Master.dbo.SysColumns sc1,
                Master.dbo.SysColumns sc2)d
  GROUP BY N
 HAVING COUNT(*) >1

 SELECT N,COUNT(*)
   FROM (SELECT TOP 1000000
                (CAST(CAST(newid() AS VARBINARY) AS BIGINT)) AS N
           FROM Master.dbo.SysColumns sc1,
                Master.dbo.SysColumns sc2)d
  GROUP BY N
 HAVING COUNT(*) >1

 SELECT N,COUNT(*)
   FROM (SELECT TOP 1000000
                ABS(CAST(CAST(newid() AS VARBINARY) AS BIGINT)) AS N
           FROM Master.dbo.SysColumns sc1,
                Master.dbo.SysColumns sc2)d
  GROUP BY N
 HAVING COUNT(*) >1