So three guys check into a fancy hotel together wanting to share a single room. The night clerk tells them the room is $300 for the night. ...

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. ...

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...

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...

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...

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...

My apologies too, Chris. Although I thought you were a really cool guy.... :blush:

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...

(Looking at watch.) I'm guessing this thread is over.

Hey Gus, are we having fun yet with Mr. MulticolumnSort?

Mr. Sanborn... have you bothered to test my solution yet?

Does it work or doesn't it?

G, he just wants a string. Zeroes = nulls = ''s. Make sure that leading zeroes are accounted for and decimals and numbers larger...

declare @u2bobnoxious table (ID int, Col1 int, Col2 int, Col3 int)

insert into @u2bobnoxious

select 1, 3, 4, ...

Yes, it should have been. Obviously it wasn't.

A number of intelligent people agree on this...

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...