Viewing 15 posts - 2,776 through 2,790 (of 4,080 total)
Just one question:
Given the sample data you have provided, what do you expect the output to look like?
"Best possible combination" is an unclear requirement. 😉
Draw us a picture, and...
__________________________________________________
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 22, 2009 at 12:35 pm
Glyn,
You will get much clearer replies, and tested solutions faster, if you can take the time to set up the problem with some sample create table scripts and data...
__________________________________________________
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 22, 2009 at 12:19 pm
And then there's Australian Rules Football....
__________________________________________________
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 22, 2009 at 12:07 pm
J: This thread is in the context of SQL 2000. Try/Catch is only valid in 2005 and beyond.
__________________________________________________
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 22, 2009 at 10:34 am
Chiun is indeed the little master, Gus.
... as she points that bow up at the necessary orbital trajectory.
INCOMING!!!
(now typing from beneath desk)
Fortunately I expect Gail is sleeping 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 21, 2009 at 2:45 pm
I'll play it safe, just the same, Steve. 😉
You never know... she might be of those Zen archers. Walks out into her yard... tests the wind......
__________________________________________________
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 21, 2009 at 1:44 pm
The woman also studies martial arts and plays with edged weapons.
I'd rather take a technical thrashing, but it strikes me as suicidal either way.
__________________________________________________
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 21, 2009 at 11:17 am
Good question, and good to know. I answered 1 because that's the length you get when you declare a string as varchar without a length. ...
__________________________________________________
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 21, 2009 at 11:14 am
Now I'm wondering who is brave enough, or ignorant enough, to try to pick on Gail?
__________________________________________________
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 21, 2009 at 10:54 am
Jan Van der Eecken (5/21/2009)
Help, he is back!
Just don't look at it Jan. Pretend it's not there and maybe it will go away.
__________________________________________________
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 21, 2009 at 10:48 am
Why don't you just use REPLACE() to change [@var] to [1] in the @sql string BEFORE you execute 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 20, 2009 at 5:01 pm
Gail: There's hope!
Many people have cats but go on to live perfectly normal lives. 😛
__________________________________________________
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 20, 2009 at 4:44 pm
GAD! Look at all the posts.
Y'all were trying to hit the 5k barrier while I wasn't watching!! Confess!!
Alvin, looks like there will be 3-4 from Oxford...
__________________________________________________
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 20, 2009 at 4:42 pm
I always wanted to hear:
Set phasers on toast.
Set phasers on deep fry.
Set phasers on cuisinart.
Hmmm....
Set phasers on truncate.
Set phasers on pork chop.
Set phasers on data corruption.
Set phasers on disaster.
__________________________________________________
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 20, 2009 at 9:18 am
Alvin, I don't OWN a banjo. 😉
I do need to come up with another verse or two, though.
__________________________________________________
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 20, 2009 at 8:58 am
Viewing 15 posts - 2,776 through 2,790 (of 4,080 total)