Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lomvardi
Starting Member
7 Posts |
 Posted - 2002-03-15 : 15:14:09
|
| I'm working with the multiple row insert openxml example at http://www.sql-server-performance.com/jb_openxml.asp but want to extend that functionality slightly.I have a parent table called Survey which I need to insert a single parent record into before I do the multiple row insert into the Answers table. The catch is that I want to insert a single record into the Survey table, grab the identity field from that insert and use it on every row in the openxml insert. Is this possible?Thanks,Chris |
|
|
lomvardi
Starting Member
7 Posts |
Posted - 2002-03-15 : 16:26:03
|
| Never mind. I figured it out.Chris |
 |
|
|
jenese
Starting Member
6 Posts |
Posted - 2002-09-24 : 11:10:41
|
| What *was* the answer? |
|
|
|
|
|
|
OPENXML, multiple row insert and @@identity