CODE EXAMPLE FOR SQL

cross apply top for each row t1

?
1
2
3
4
5
6
7
8
9
10
11
SELECT  *
FROM    [20090716_cross].table1 t1
CROSS APPLY
(
SELECT  TOP (t1.row_count) *
FROM    [20090716_cross].table2
ORDER BY
id
) t2
ORDER BY
t1.id, t2.id