Viewing 15 posts - 3,541 through 3,555 (of 4,080 total)
EDITED TO REPORT TEST RESULTS
Use Lowell's dynamic SQL method above. It's simpler, faster, and will only increase its lead as the number of words in the
search string...
__________________________________________________
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 6, 2009 at 9:00 pm
Many beers in fridge, we can make a campfire out back with the ISO standards.
By the way, does anyone else here follow the online comic XKCD?
It 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 6, 2009 at 8:18 pm
I have never before attempted this feat without a net, but my wife is asleep, so I'll take a shot at it. You DO know this is going...
__________________________________________________
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 6, 2009 at 7:43 pm
Great... you mention Joe Celko and now I've got the title song to Flash Gordon running through my head.
__________________________________________________
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 6, 2009 at 7:02 pm
Does that mean all pork chops, katanas, longbows, and trebuchets would have to be checked at the door? Doesn't sound like much of a party to me......
__________________________________________________
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 6, 2009 at 6:50 pm
Fine then. Me and Roy will just pack up our CTEs and go home.
__________________________________________________
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 6, 2009 at 6:43 pm
I take the afternoon to focus on my day job and come back to find all this? My oh my.
Thanks to all y’all who supported “my” solution...
__________________________________________________
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 6, 2009 at 6:32 pm
Nah.... I'd never get invited.
Seriously, what is to be gained by exclusivity? If you have a complex topic or problem you want to discuss, why not just ask...
__________________________________________________
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 6, 2009 at 5:10 pm
Amen.
(This was in response to Lynn not being a Saint, and therefore not being dead.)
__________________________________________________
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 6, 2009 at 5:08 pm
After considerable pondering, I've eventually come around to "If it ain't broke, don't fix it." I know I prefer this forum, and it's because there is so much...
__________________________________________________
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 6, 2009 at 5:07 pm
But I do have to take into account that he may have earned the MVP thing, just not through stellar application of clever implementations of T-SQL.
I could accept that...
__________________________________________________
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 6, 2009 at 12:25 pm
Sloppy typing on my part guys. "MSDN MVP" should read in full "MVP / MSDN Moderator". Please understand that I have great respect for 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 6, 2009 at 11:50 am
question about putting comments on query
There's nothing wrong with comments. Their use is to be encouraged and applauded, yet rarely do I feel the need to...
__________________________________________________
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 6, 2009 at 11:20 am
One nice thing about searching syscomments is that it SOMETIMES catches a string being built in dynamic SQL.
__________________________________________________
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 6, 2009 at 10:16 am
KA-CHING!
Mr. MSDN MVP just joined a fairly well settled thread to offer a solution "very easy to understand and modify as well." Of course it had twice...
__________________________________________________
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 6, 2009 at 10:12 am
Viewing 15 posts - 3,541 through 3,555 (of 4,080 total)