Link to home
Start Free TrialLog in
Avatar of Scott Baldridge
Scott Baldridge

asked on

Loop with SCOPE_IDENTITY()

Hello, I need to loop through table a and insert into table b get the SCOPE_IDENTITY() and use that to insert more data from table a into table c using the SCOPE_IDENTITY() .

table a is a flat table with company and worker information.
table b will become company table
table c will become worker table using company.Id(SCOPE_IDENTITY() ) as worker.companyId.

What is the best way to do this type of statement?
ASKER CERTIFIED SOLUTION
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Only possible answer for the question.