Viewing 15 posts - 2,866 through 2,880 (of 4,080 total)
If I sounded like my avatar, it would be some kind of klaxon/alarm bell/buzzer/siren/end-of-the world noises. 😀
By the way, I'm now having to deal with a table named...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 6, 2009 at 2:03 pm
Flo: I was being a trifle ironic, maybe even a touch sarcastic. 😉
Although, I am sorry to say, I have at times written queries containing...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 6, 2009 at 1:08 pm
Why shouldn't he put quotes around 'NULL', Alvin?
'NULL' is a perfectly good word. Isn't it? :unsure:
BTW, I was also crushed when...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 6, 2009 at 12:42 pm
You always have the option to avert your eyes and let others assist him.
They might give him bad advice though.
He might even take it.
BTW, if I ever...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 6, 2009 at 12:16 pm
Hey Lynn:
He probably learned about SSC early in his academic career, maybe even got hired with the help of SSC, and may get his Ph.D. with SSC assistance as well....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 6, 2009 at 12:07 pm
I misunderstood, sorry about that. You are wanting to build the values you originally posted.
A summary query either before or after would give you...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 6, 2009 at 8:24 am
Feels good, doesn't it? 😉
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 6, 2009 at 8:06 am
Um.... yeah..... :w00t: I obviously haven't had enough caffeine this morning.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 6, 2009 at 8:01 am
What's ridiculous about cutting 25% of the work out? If you can do that with everything that runs on your SQL server, you are doing well.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 6, 2009 at 7:14 am
I assume you are partitioning on column 3, and that by "top-ranked" you mean the rows where row_number() = 1.
I'm changing up the data a bit in the example below...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 6, 2009 at 7:09 am
Tables have fields???? 😀
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 6, 2009 at 6:55 am
No problem. Did any of the answers posted work for you?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 6, 2009 at 6:53 am
anyone?
I was waiting for you to post up the samples I requested, partner. 😉
By failing to do that, you have people guessing at...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 6, 2009 at 6:18 am
That's cool and sort of lovely, Gail. Thanks for sharing.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 5, 2009 at 2:00 pm
Hmmmm.... someone discovered DBCC TIMEWARP.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 5, 2009 at 1:54 pm
Viewing 15 posts - 2,866 through 2,880 (of 4,080 total)