|
|
Posted by Hugo Kornelis on 01/30/08 21:48
On Wed, 30 Jan 2008 13:18:26 -0800 (PST), t8ntboy wrote:
>ASP/SQL Server Express 05
>
>I have two tables, A and B. I would like to insert multiple records
>into both form A and B, but a field in form B is the Record ID in form
>A. So, I need to insert the records into A, collect the ID and then
>insert into B. I have no problem doing this for individual records;
>I am not sure what the best way to this is for multiple records being
>inserted at the same time.
>
>How would you accomplish this if you were me?
>
>Any help would be appreciated tremendously.
Hi t8ntboy,
Assuming that TableA_ID is the generated surrogate key and TableA_Key is
the "real" key, you can fetch the generated surrogate key values by
querying TableA "after" the insert with a join on the table with
inserted values, like this:
SELECT A.TableA_ID, (other column)
FROM TableA AS A
INNER JOIN Staging_Table AS S
ON S.TableA_Key = A.TableA_Key;
--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Navigation:
[Reply to this message]
|