Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE #el_heapo (id INT, yourmom INT)
- INSERT #el_heapo ( id )
- VALUES ( 1 )
- INSERT #el_heapo ( id )
- VALUES ( 2 )
- INSERT #el_heapo ( id )
- VALUES ( 3 )
- INSERT #el_heapo ( id )
- VALUES ( 4 )
- INSERT #el_heapo ( id )
- VALUES ( 5 )
- SELECT *
- FROM #el_heapo AS eh
- +----+---------+
- | id | yourmom |
- +----+---------+
- | 1 | NULL |
- | 2 | NULL |
- | 3 | NULL |
- | 4 | NULL |
- | 5 | NULL |
- +----+---------+
- INSERT #el_heapo ( id )
- VALUES ( 1 )
- INSERT #el_heapo ( id )
- VALUES ( 2 )
- INSERT #el_heapo ( id )
- VALUES ( 3 )
- INSERT #el_heapo ( id )
- VALUES ( 4 )
- INSERT #el_heapo ( id )
- VALUES ( 5 )
- +----+---------+
- | id | yourmom |
- +----+---------+
- | 1 | NULL |
- | 2 | NULL |
- | 3 | NULL |
- | 4 | NULL |
- | 5 | NULL |
- | 1 | NULL |
- | 2 | NULL |
- | 3 | NULL |
- | 4 | NULL |
- | 5 | NULL |
- +----+---------+
- CREATE CLUSTERED INDEX cx_id ON #el_heapo (id);
- +----+---------+
- | id | yourmom |
- +----+---------+
- | 1 | NULL |
- | 1 | NULL |
- | 2 | NULL |
- | 2 | NULL |
- | 3 | NULL |
- | 3 | NULL |
- | 4 | NULL |
- | 4 | NULL |
- | 5 | NULL |
- | 5 | NULL |
- +----+---------+
- INSERT #el_heapo ( id )
- SELECT TOP 1000000
- x.n % 5 + 1
- FROM (
- SELECT ROW_NUMBER() OVER ( ORDER BY @@SPID )
- FROM sys.messages AS m
- CROSS JOIN sys.messages AS m2
- ) AS x(n);
- SELECT eh.id
- FROM #el_heapo AS eh
- ORDER BY eh.yourmom
Add Comment
Please, Sign In to add comment