MS SQL 2008 Adding Records to multiple tables at once
Posted on 2013-02-05
I am trying to build two tables (Table1 and Table2) from Master table all at once. When a record is added to Table1 and the Identity field is populated I need that column, t1.Id, to be populated into t2.IdTable1 column, plus different fields from the Master table will fill columns in Table1 and Table2.
Does this make sense? If you need further explination please let me know.
Thanks in advance for the help.