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

Source: explainextended.com

Similar codes

0 vote158 views1 answer
Narural join
SQL
0 vote153 views1 answer
Multiple left join mysql
SQL
3 votes165 views1 answer
Mysql replace string in table
SQL
0 vote153 views1 answer
SQL isnumeric DB2
SQL
0 vote219 views1 answer
How to get table current identity value in sql server
SQL
3 votes149 views1 answer
Sql case update
SQL
0 vote146 views1 answer
Min:sec datediff mssql
SQL
0 vote203 views1 answer
Delete from IN subquery
SQL
5 votes173 views1 answer
Get column name sql server
SQL
2 votes148 views1 answer
Oracle find unusable indexes
SQL