RE: Insert Into with nested Selects

SSC Guru

Points: 1003863

April 7, 2014 at 4:32 pm

Sean Lange (4/7/2014)
Jeff Moden (4/7/2014)
Why are we inserting into an IDENTITY column???? :ermm::blink::crying::pinch::sick:
Sounds to me like the OP is going inserting data that was missed in the original programming. Therefore you need to insert those values into the identity column to ensure RI.

I hope that's the reason and not some misconception that PK reusage is a good idea or worse. I'm hoping the OP will answer on this one.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)