Figure 5: SQL Server 2000 NTILE(8) query result: even distribution of additional rows
orderid qty rownum tile
10001 10 1 1
10006 10 2 1
30001 10 3 2
40005 10 4 3
30003 15 5 3
20001 20 6 4
20002 20 7 5
30004 20 8 6
10005 3 9 6
30007 30 10 7
40001 40 11 8