Home Forums SQL Server 2012 SQL Server 2012 - T-SQL How to loop through one table column values and insert another table in proceudre logic RE: How to loop through one table column values and insert another table in proceudre logic
Ed Wagner
SSC Guru
Points: 287024
More actions
January 31, 2016 at 3:38 pm
#1855585
To add one point to what pietlinden said, you can CROSS JOIN more than 2 tables and it generates a row for every possible combination of rows. For example, if you have 3 tables of 2 rows each, you'll get 8 (2 * 2 * 2) rows back.
Tally Tables - Performance PersonifiedString Splitting with True PerformanceBest practices on how to ask questions