Viewing 15 posts - 55,591 through 55,605 (of 59,072 total)
--===== Setup a test table to demonstrate the solution. -- THIS IS NOT PART OF THE SOLUTION!!! It's just test data! DECLARE @yourtable TABLE (ID INT PRIMARY KEY, [User] INT, Test...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 30, 2007 at 8:35 pm
Heh... I used to seriously question cursors… now, I LOVE cursors and RBAR While Loops, too! Even better than that, I LOVE code that looks set-based (no While loops)...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 30, 2007 at 7:43 pm
Vamshi,
Did you ever resolve your problem? If not, you might want to check out "Expanding Hierarchies" in Books Online.
--Jeff Moden
Change is inevitable... Change for the better is not.
July 30, 2007 at 5:32 pm
Thanks, Markus... but tell us... what did you have in mind? Both scripts return the necessary information (we thought) you were requesting... what's missing?
--Jeff Moden
Change is inevitable... Change for the better is not.
July 30, 2007 at 5:11 pm
Maybe in the last SELECT but the rest of it is based almost exactly on what you did, Lowell. I just changed it a bit just 'cause I like changing...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 30, 2007 at 5:09 pm
Shoot... way too late for that request, eh ![]()
--Jeff Moden
Change is inevitable... Change for the better is not.
July 30, 2007 at 5:04 pm
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...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 30, 2007 at 7:15 am
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...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 29, 2007 at 8:22 am
He even changed the name!!! Did you look at THIS piece of code?
--Jeff Moden
Change is inevitable... Change for the better is not.
July 29, 2007 at 7:33 am
Did you even look at Peter's code, Vamshi?
Looks to me like it returns more than just depth... he even changed the title...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 29, 2007 at 7:24 am
Nah... get too many right like this and you might "BE" a "Specialist" ![]()
--Jeff Moden
Change is inevitable... Change for the better is not.
July 29, 2007 at 7:20 am
Oooooh.... now I know we've got to work together, Remi ![]()
--Jeff Moden
Change is inevitable... Change for the better is not.
July 28, 2007 at 9:42 pm
I guess BULK INSERT and OSQL would be way to complicated, huh ![]()
--Jeff Moden
Change is inevitable... Change for the better is not.
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...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 28, 2007 at 3:59 pm
With you? You know the answer to that, Remi... ANYTIME.
--Jeff Moden
Change is inevitable... Change for the better is not.
July 28, 2007 at 3:57 pm
Viewing 15 posts - 55,591 through 55,605 (of 59,072 total)