With this project I needed to insert data into table1 from table2 while simultaneously retrieving the identity field of table1, then insert that identity into table3 which mapped to table2 on a key that table1 did not have.
The OUTPUT clause when used with the input statment would not facilitate this because it could not return [...]
Archive of posts tagged output