Viewing 15 posts - 2,521 through 2,535 (of 4,080 total)
Since a join shows all combinations of the joined tables in the result set, whether or not those columns are displayed, you must be getting unexpected combinations. Select...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 25, 2009 at 11:43 pm
I hope you are also asking this question in an ORACLE forum.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 25, 2009 at 11:33 pm
Hey Jeff,
If you can spare a minute, would you mind revisiting this topic and double-checking me? I improved on the performance, but something doesn't feel right.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 25, 2009 at 11:19 pm
I don't know why everything in the code above is showing up in red. Maybe the PRINT statement?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 25, 2009 at 10:54 pm
Lynn, I'm sending you a can of halo polish for Christmas.
You must use it constantly and in large quantities.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 25, 2009 at 10:50 pm
Gugan and Peter,
I rewrote the CTE solution to account for strings that have no '1's. It now shows a zero to represent such strings. In...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 25, 2009 at 10:41 pm
Upon reflection, I must concede that where work (such as taking a count) can be done on a web application prior to calling a procedure, it takes the load off...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 25, 2009 at 8:22 pm
Yes, I understand that it is an example. But it is inconsistent to hard code a set of values and then to say that a count of those...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 25, 2009 at 6:11 pm
Nice work, Peter! I totally missed thinking about the issue of same values. Good catch.
I should go back and test my old code with a...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 25, 2009 at 3:43 pm
Barry: Want me to send you a good book or two? The real, old-fashioned kind made out of paper?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 25, 2009 at 2:59 pm
Oh yeah.... I tend to forget about the purpose of all this. I just play for love of the game.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 25, 2009 at 2:57 pm
Guess what happens when you print @@error? It resets to 0 because the PRINT statement executed successfully. Try commenting that out.
Best practice...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 25, 2009 at 2:27 pm
( I'd say you're welcome, but I thought you wanted to have the last word.)
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 25, 2009 at 1:42 pm
If you are going to hard code the WHERE clause to be (1,2,4,8), why don't you just go ahead and say = 4?
What if someone makes a typo and has...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 25, 2009 at 1:35 pm
How are you feeling, Barry?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 25, 2009 at 1:34 pm
Viewing 15 posts - 2,521 through 2,535 (of 4,080 total)