Viewing 15 posts - 55,576 through 55,590 (of 59,067 total)
Heh... nicely done, Peter... forgot all about our mutual friend, Mister Cross-Tab.
July 31, 2007 at 8:40 pm
Heh... I'd have to say you've outlined an impossible scenario and you need to ask better questions.
Not possible to not have...
July 31, 2007 at 8:36 pm
Nope… you hit the nail on the head, Andy. People DO need to reevaluate what it is they're doing. One of your points hit a particularly sore spot with...
July 31, 2007 at 8:35 pm
Correct... SSN would be one example of such a key.
July 31, 2007 at 5:01 pm
Susan,
Cole kinda hijacked your post... do you still need help or are you all set?
July 31, 2007 at 4:57 pm
Missing a key piece of information here... basically, what does all that code do? I see stuff like 'Level 3' in it... is it meant to produce some sort of...
July 31, 2007 at 4:55 pm
You bet, Sakthi... thanks for the feedback.
July 31, 2007 at 4:46 pm
First, the lecture...
If you want good quality help in a timely fashion, you must take the time to post your data in the form of a CREATE TABLE along with...
July 31, 2007 at 7:46 am
Funny how this works... everyone seems to say that performance isn't all that important... but, why do they buy the high performance hardware if performance is not important? And why do so...
July 30, 2007 at 9:07 pm
--===== 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...
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)...
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.
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?
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...
July 30, 2007 at 5:09 pm
Viewing 15 posts - 55,576 through 55,590 (of 59,067 total)