Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- declare @i nvarchar(9) = '2d100'
- ;with p as(select left(@i,charindex('d',@i)-1)m,cast(substring(@i,charindex('d',@i)+1,9) as int)d)
- ,r as(select 1 n,cast(crypt_gen_random(2)%d+1 as nvarchar(max))r from p union all select n+1,cast(
- r+' '+cast(crypt_gen_random(2)%d+1 as nvarchar(max))as nvarchar(max))from r,p where n<m)select r
- from r,p where n=m
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement