Viewing 15 posts - 55,606 through 55,620 (of 59,078 total)
Did you even look at Peter's code, Vamshi?
Looks to me like it returns more than just depth... he even changed the title...
July 29, 2007 at 7:24 am
Nah... get too many right like this and you might "BE" a "Specialist" ![]()
July 29, 2007 at 7:20 am
Oooooh.... now I know we've got to work together, Remi ![]()
July 28, 2007 at 9:42 pm
I guess BULK INSERT and OSQL would be way to complicated, huh ![]()
July 28, 2007 at 4:04 pm
Sure... I can see two levels like that... but N levels for invoices?
The only way I can see something like that happening...
July 28, 2007 at 3:59 pm
With you? You know the answer to that, Remi... ANYTIME.
July 28, 2007 at 3:57 pm
Would be nice if you posted your solution so the rest of us can learn something... ![]()
July 28, 2007 at 12:43 pm
Thats nice Dan... wanna share your solution? Information does travel in two directions... ![]()
July 28, 2007 at 12:42 pm
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,...
July 28, 2007 at 12:37 pm
Heh... went to the doctor and said "Doc, if I raise my arm like this... it hurts". Doctor said not to do that anymore
July 28, 2007 at 9:37 am
I agree... in SQL Server 2005, you could probably do it with a recursive CTE... But not in 2K. Might be able to do it using a recursive UDF, but...
July 28, 2007 at 9:19 am
Ya do pretty darned well yourself, Lowell!
You made a very useful tool. I'm in the process of tweaking it for my own use and thought...
July 28, 2007 at 9:13 am
Nicely done, Lowell... you might want to check the ##Tmp table, though... the numeric datatypes always end up having a MaxActualLength of "0" and I think that's probably not right....
July 27, 2007 at 8:17 pm
Viewing 15 posts - 55,606 through 55,620 (of 59,078 total)