SQL snippets

with randowvalues
    as(
       select 1 id, CAST(RAND(CHECKSUM(NEWID()))*100 as int) randomnumber
        union  all
        select id + 1, CAST(RAND(CHECKSUM(NEWID()))*100 as int) randomnumber
        from randowvalues
        where 
          id < 1000
      )
 
select * from randowvalues OPTION(MAXRECURSION 0);