Guest User

Untitled

a guest
May 24th, 2018
187
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.40 KB | None | 0 0
  1. CREATE TABLE #el_heapo (id INT, yourmom INT)
  2.  
  3. INSERT #el_heapo ( id )
  4. VALUES ( 1 )
  5. INSERT #el_heapo ( id )
  6. VALUES ( 2 )
  7. INSERT #el_heapo ( id )
  8. VALUES ( 3 )
  9. INSERT #el_heapo ( id )
  10. VALUES ( 4 )
  11. INSERT #el_heapo ( id )
  12. VALUES ( 5 )
  13.  
  14. SELECT *
  15. FROM #el_heapo AS eh
  16.  
  17. +----+---------+
  18. | id | yourmom |
  19. +----+---------+
  20. | 1 | NULL |
  21. | 2 | NULL |
  22. | 3 | NULL |
  23. | 4 | NULL |
  24. | 5 | NULL |
  25. +----+---------+
  26.  
  27. INSERT #el_heapo ( id )
  28. VALUES ( 1 )
  29. INSERT #el_heapo ( id )
  30. VALUES ( 2 )
  31. INSERT #el_heapo ( id )
  32. VALUES ( 3 )
  33. INSERT #el_heapo ( id )
  34. VALUES ( 4 )
  35. INSERT #el_heapo ( id )
  36. VALUES ( 5 )
  37.  
  38. +----+---------+
  39. | id | yourmom |
  40. +----+---------+
  41. | 1 | NULL |
  42. | 2 | NULL |
  43. | 3 | NULL |
  44. | 4 | NULL |
  45. | 5 | NULL |
  46. | 1 | NULL |
  47. | 2 | NULL |
  48. | 3 | NULL |
  49. | 4 | NULL |
  50. | 5 | NULL |
  51. +----+---------+
  52.  
  53. CREATE CLUSTERED INDEX cx_id ON #el_heapo (id);
  54.  
  55. +----+---------+
  56. | id | yourmom |
  57. +----+---------+
  58. | 1 | NULL |
  59. | 1 | NULL |
  60. | 2 | NULL |
  61. | 2 | NULL |
  62. | 3 | NULL |
  63. | 3 | NULL |
  64. | 4 | NULL |
  65. | 4 | NULL |
  66. | 5 | NULL |
  67. | 5 | NULL |
  68. +----+---------+
  69.  
  70. INSERT #el_heapo ( id )
  71. SELECT TOP 1000000
  72. x.n % 5 + 1
  73. FROM (
  74. SELECT ROW_NUMBER() OVER ( ORDER BY @@SPID )
  75. FROM sys.messages AS m
  76. CROSS JOIN sys.messages AS m2
  77. ) AS x(n);
  78.  
  79. SELECT eh.id
  80. FROM #el_heapo AS eh
  81. ORDER BY eh.yourmom
Add Comment
Please, Sign In to add comment