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.

Me, too! 😀

Thanks! I found it very interesting for Regular expression syntax.

I get it wrong, but I like this kind of questions.

Thanks.