Advertisement
Guest User

Untitled

a guest
May 29th, 2016
54
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.29 KB | None | 0 0
  1. use master;
  2. go
  3.  
  4. SELECT TOP(5000)
  5. a.name,
  6. replicate(a.status,10) as col2
  7. FROM master..spt_values a
  8. CROSS JOIN master..spt_values b; -- 6345361 rows = 2519 * 2519
  9. GO
  10.  
  11. select distinct
  12. v.number
  13. from master..spt_values as v
  14. where v.number > 0 and v.number <= 2048
  15. order by v.number asc
  16. go
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement