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

5 votes245 views1 answer
Update sql user password
SQL
1 vote222 views1 answer
Mysqldump: couldn't execute 'select column_name,
SQL
1 vote264 views1 answer
Mysql select another database
SQL
0 vote280 views1 answer
Where to find pg_hba.conf in ubuntu
SQL
1 vote277 views1 answer
Print all records of table in mysql
SQL
2 votes276 views1 answer
Mariadb json select
SQL
1 vote264 views1 answer
Sql avg group by
SQL
1 vote275 views1 answer
Continue in sql
SQL
0 vote266 views2 answers
Update query with between in mysql
SQL
1 vote275 views1 answer
SQL: merging multiple row data in string
SQL