Steve Jones - SSC Editor (2/1/2012)

---

My apologies. I think I selected the wrong answer when reworking things. The original answers weren't quite clear, so I altered them.

I have fixed things,...

Hugo Kornelis (1/31/2012)

---

Meh, I don't like questions where people who really understand the subject have a 50/50 chance of getting it right because they have to second-guess the author's intention.

"Is...

+1

It seems too easy. So, I digged in deep on google and MSDN.

Thanks for the qotd. 😀

Another question "Please, my points back!"

WOW! First time, I answered right 10 qotd consecutively. 😀

I like qotd about new and/or particular feature.

Thanks!

😀

That's a good idea: a beefsteak of reindeer.

I'd like deepen the argument, but i've limited time.

I agree.

Easy and too long question.

charlietuna (10/23/2011)

---

The solution seems a bit opaque. Something like this is (to me) much more straightforward for the next person who has to read it:

update #t

set col1 = case col1...

In fact, the TOP clause with the "ORDER BY", in this case, is...

paul.knibbs (10/21/2011)

---

Carlo Romagnano (10/21/2011)

---

CREATE VIEW vw_clients AS

SELECT TOP 100 PERCENT Code, Name FROM Clients

ORDER BY Code

I am curious to know if the VIEW above always returns records in sorted...

CREATE VIEW vw_clients AS

SELECT TOP 100 PERCENT Code, Name FROM Clients

ORDER BY Code

I am curious to know if the VIEW above always returns records in sorted order.