Home Forums SQL Server 2005 SQL Server 2005 General Discussion how to loop and insert records RE: how to loop and insert records
SQLZ
SSChampion
Points: 12872
More actions
April 1, 2008 at 4:54 am
#796368
Hi Patrick,
I'm not sure you'd need to use a loop. Would a cross join not work?
select sid, pid, mid
from testA, TestC
Karlsource control for SQL Server