Better than that, why do you think you need a function at all?  *sniff* *sniff* I smell some RBAR coming up

This should do it for you... includes a test setup so you can "play"...

--===== If the test table exists, drop it

     IF OBJECT_ID('TempDB..#yourtable') IS NOT NULL

        DROP TABLE...

Nicely done, Michael. Real good to see someone actually do a comparison in performance, too.

Since you were kind enough to mention my name, I have to sing the praises of...

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?