Inserting into multiple tables, how to get the PK.

[darwin101]

hi all
I need to insert client records from a csv file into multiple tables. the client table creates the pk,clientId. how would I go about getting that clientId to insert the remainder of the records into different tables? if you could point me at an example of similar code or instructions I would be most appreciative. I am thinking a cursor would be envolved, but I have never written one.

thnks

 

[SQLDenis]

use scope_identity()

here is an sample script

create table test1 (id int identity primary key, someDate datetime)

create table test2(id int, id2 int FOREIGN KEY (id2) REFERENCES test1(id))
GO
declare @pk int
insert test1 values(getdate())

select @pk = scope_identity()
insert test2 values(1,@pk)

GO
select * from test1

select * from test2
GO

drop table test2,test1
GO

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/