Shoot... way too late for that request, eh

Heh... triangular joins have been around a lot longer than I've been writing SQL so I can't take any credit for them.  Actually, I don't like either method just because they...

OK... Now I see and I've got a bit of egg on my face... there's actually a couple of errors in Peter's code

Sorry...

He even changed the name!!!  Did you look at THIS piece of code?

Did you even look at Peter's code, Vamshi?   Looks to me like it returns more than just depth... he even changed the title...

Nah... get too many right like this and you might "BE" a "Specialist"

Oooooh.... now I know we've got to work together, Remi 

I guess BULK INSERT and OSQL would be way to complicated, huh

Sure... I can see two levels like that... but N levels for invoices?   The only way I can see something like that happening...

With you?  You know the answer to that, Remi... ANYTIME.

Would be nice if you posted your solution so the rest of us can learn something...

Thats nice Dan... wanna share your solution?  Information does travel in two directions...

Between the join to the inserted table (which will cause the WHERE and ON clauses to be totally recalculated for every row inserted) and the correlated subquery in the WHERE clause,...

Heh... "Particle Physics for Dummies"

Heh... went to the doctor and said "Doc, if I raise my arm like this... it hurts".   Doctor said not to do that anymore