Thanks, Serqiy... what does the key look like?  And, actually... .1 second to insert only 80 rows across 9 tables seems a bit slow but lemme withhold judgement on that...

IDENTITY is an algorithm and is the "completely sythethic" key that Erland Sommarkskog is referring to in Type C.

I certainly don't mean to pick on anyone but I've seen endless...

Ok... I feel much better... for a minute, I thought one of my old friends had actually lost his mind...

Daniella...

Serqiy's point is...

Nope, Ken... none of that is directed at you and I think you did just fine... I think Daniella may have a larger problem if she's got a 3 level...

What did we do prior to the introduction of the identity column?

Oh good grief... here we go again... ...

SG,

Normally, a couple of us would answer the question of "What am I doing wrong?" with "You're using a cursor".

Rather than trying to salvage this code, I think it would...

Ack! Not enough coffee!  Took me a bit to figure out what the heck Serqiy and Eric were yakking about... took a look at Eric's previous post... I get it......

Thanks for sharing the results of your test, Gail...

I remember reading the same article (although I can't find it anymore)... it used a homegrown sp to "renumber" the ID's of the triggers so that they would fire in...

Daniella... What did it?  Scope_Identity?

Serqiy, surely you are not one of those that believes that every table should have a natural key, are you?

Ummm..... that's a bit wierd if you try following the signature path of this one...

PW is correct AND....

You will probably have to use the machine name and path instead of drive name and path.  AND, your server must startup as something that has privs...

Here, Here!  Learn to work with NULLs on this type of thing.  There is a great value to NULLs in a column like this especially if you allow future enddating.