Bill,

I'm well aware of NextID tables (sequence tables) and the methods to use them without causing a bottle-neck without any chance of a deadlock or extended wait even during the...

Oracle is case sensitive for table and column names and must be upper case during this type of transfer.  Put the quotes back in and modify the things in quotes...

What does the number of years have to do with the person count?

Moot point... the problem is that you are creating a "triangular join" with the "less than" condition... it's...

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......