You're reading too much into it. There's just 1 table, and I'm inserting 1
record. I can't insert IDENTITY into that record during the insert
because I don't get it (SELECT myvar = IDENTITY) until after the insert.
Then, I have to go back and update the record to add it once I get
IDENTITY. The question is just can I do this all in one step? Can I add
IDENTITY into a field at the time of the insert?
"Dean Savovic" <hr> wrote in message