Viewing 15 posts - 3,406 through 3,420 (of 4,080 total)
I am starting to cringe. Two threads
Sacrilege!!
Heresy!!
There can only be One!!
I think I need to go take my meds, now...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 16, 2009 at 9:36 am
All hail The Thread... Eternal is The Thread... Great is The Thread... Mighty Mighty is The Thread.
Let us make great sacrifice of cursors and recursive CTEs....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 16, 2009 at 9:10 am
Why do I suspect that we're slowly being led to a point where he wants us to solve an actual problem at work, rather than just a general rant as...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 16, 2009 at 8:05 am
Can we just take this one off the fire? It's obviously done. If anyone cares, he posted the exact same rant over in the MS forums...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 16, 2009 at 7:30 am
Owch, I forgot all about that. You're exactly right, Jack. Good save, and thank you.
The thread is definitely worth reading in it's entirety, because the...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 16, 2009 at 7:14 am
Thank you, sir. Good job, and good night.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 15, 2009 at 9:47 pm
Hey Bruce,
If they're going to go that far, why not just help write some front-end editing and leave the db out of it? Or is this 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
March 15, 2009 at 9:32 pm
If you're going to do that, Steve, you should also edit the subsequent posts where people quoted him.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 15, 2009 at 9:30 pm
You are correct that you have to define the columns in advance for PIVOT. This isn't a problem for [storeName], but it is for [itemName] because your...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 15, 2009 at 9:14 pm
Here is the code I should have posted earlier.
-----------------------------------------------------------------------------------------------
-- code to generate temporary sample data table for testing purposes
-----------------------------------------------------------------------------------------------
declare @words table (wordID int primary key, word varchar(20))
insert into @words
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
March 15, 2009 at 4:59 pm
I believe Mangal stated at some point that his primary area of expertise was BI, however, he enjoys SQL. He likes CTEs. SELECT statements make...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 15, 2009 at 12:30 pm
Sounds like you're good to go then. I was just throwing out ideas about a few "gotchas" I ran across the first time around. Looks like...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 15, 2009 at 11:53 am
Stick with your RBAR animation. It's extremely cool.
how many times those numbers of milliseconds are going to be used as part of a function
This is...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 15, 2009 at 11:25 am
It should work well for you.
Do you have some sort of convention for distinguishing those databases which should be queried from others which shouldn't? You can...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 15, 2009 at 11:20 am
You can build and execute dynamic SQL within your loop. I use this approach to build qualified table names for databases that reside on linked servers....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 15, 2009 at 11:07 am
Viewing 15 posts - 3,406 through 3,420 (of 4,080 total)