Viewing 15 posts - 3,196 through 3,210 (of 4,080 total)
Hey Andrew 🙂
This is a case of differing interpretations about the true nature of the question.
My solution would in fact produce the last result you stated. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 2, 2009 at 7:13 pm
All things are possible if one only understands, Flo....
Now David, this is going to very likely produce a table scan execution plan, unless you have indexes on all of...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 2, 2009 at 6:16 pm
Luis, you have no FROM clause. You can't do an inner join without one.
If the inner join is supposed to be to the table being updated just use...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 2, 2009 at 5:37 pm
Kit, in my house we had a "Board of Education" which was applied to "The Seat of Learning."
My brothers and I were well-behaved.
Jeff, I have a post...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 2, 2009 at 5:18 pm
Christian;
If I understand Mr. Sanborn correctly, and I still chastise him for lack of clarity, he wants to sort while ignoring zeros and nulls. I base this on...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 2, 2009 at 4:57 pm
My apologies too, Chris. Although I thought you were a really cool guy.... :blush:
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 2, 2009 at 3:45 pm
No that's correct. You ignore the zero in column 1.
That's exactly what my case statement is intended to accomplish.
So the sort order is
235....
359....
412....
523
The STR...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 2, 2009 at 3:10 pm
(Looking at watch.) I'm guessing this thread is over.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 2, 2009 at 3:00 pm
Hey Gus, are we having fun yet with Mr. MulticolumnSort?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 2, 2009 at 1:59 pm
Mr. Sanborn... have you bothered to test my solution yet?
Does it work or 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
April 2, 2009 at 1:57 pm
G, he just wants a string. Zeroes = nulls = ''s. Make sure that leading zeroes are accounted for and decimals and numbers larger...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 2, 2009 at 1:29 pm
declare @u2bobnoxious table (ID int, Col1 int, Col2 int, Col3 int)
insert into @u2bobnoxious
select 1, 3, 4, ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 2, 2009 at 1:27 pm
the sample I posted should be self explanatory
Yes, it should have been. Obviously it wasn't.
A number of intelligent people agree on this...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 2, 2009 at 10:13 am
Jack, I'm not suggesting at all that anyone should say DON'T HELP THIS PERSON by posting those links. If I was going that route, I would just suggest...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 2, 2009 at 8:52 am
Just a thought here... but it suddenly dawned on me that any time he posts, it might not hurt to post the set of links Gail compiled as background for...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 2, 2009 at 8:15 am
Viewing 15 posts - 3,196 through 3,210 (of 4,080 total)