Viewing 15 posts - 1,771 through 1,785 (of 4,080 total)
Always feel free to tweak away, Paul.
__________________________________________________
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 22, 2010 at 2:23 pm
Don't define something in a RETURN that you don't actually want to return. You need to omit that column.
This means that you will...
__________________________________________________
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 22, 2010 at 12:51 pm
Dave's right. Here's a good practice tip:
@@ROWCOUNT changes with each new SET or SELECT, so if you want to hold on to 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 22, 2010 at 12:13 pm
The bit about COLLATEs is new to me. I'll have to test it out. Where did you pick up that bit of information?
__________________________________________________
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 20, 2010 at 3:32 pm
I'm sure there must be a spatial solution too.
I finally throw up a solution you like, so you critique my set up of the sample data. There's no...
__________________________________________________
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 20, 2010 at 3:30 pm
No recursive CTE this time, Paul? 😉
__________________________________________________
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 20, 2010 at 3:15 pm
This will let you replace a set of words with whatever replacements you choose.
declare @tab table (findWord varchar(50) primary key, replaceWord varchar(50))
declare @result varchar(4000)
declare @string varchar(4000)
set @string = 'here...
__________________________________________________
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 20, 2010 at 3:05 pm
Actually, I misunderstood the requirements. Sorry. I shouldn't try to work when I'm tired.
My solution reaches back to the last valid value for 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 19, 2010 at 3:08 pm
Thanks G2, I see. But why would anyone want to live in the top part of the refrigerator?
A good question... but people ask ME why I live where temperatures routinely...
__________________________________________________
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 19, 2010 at 9:00 am
To be honest, there is no comparing winter down south to winter up north. Especially this year. We get at most a few weeks of temperatures...
__________________________________________________
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 19, 2010 at 8:24 am
I can't get that excited about a school whose cheerleaders all resemble Admiral Ackbar... with curls.
__________________________________________________
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 19, 2010 at 8:04 am
I remember the first time I ever had a gin and tonic. The invitation to go out for happy hour went something like this.
1. Spring 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 19, 2010 at 7:47 am
Grant, did you by any chance attend mighty Miskatonic University? Home of the Fightin' Shoggoths?
__________________________________________________
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 19, 2010 at 7:29 am
And what about those Midwestern States... Ohio... Iowa? Talk about consonant-challenged.
__________________________________________________
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 19, 2010 at 7:01 am
Or Alabama?
__________________________________________________
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 19, 2010 at 7:00 am
Viewing 15 posts - 1,771 through 1,785 (of 4,080 total)