Good question. Brushed up things on sorting. 🙂

Very good question. 🙂

It's getting created successfully without any issue.

It's pretty simple. Remove the alias "AS" from each of the update statement.

UPDATE @Results

SET PhaseType = CASE ...END AS PhaseType

UPDATE @Results

SET TQSDComment = SDAAFV.txtValue AS TQSDComment

UPDATE @Results...

Neeraj, I already checked that link but since it was old (probably in 2009 or 2010, so wanted to know...

Sometimes the easiest question with so many points at stake gives you so much doubt. But somehow i was able to crack it. :laugh:

Simple straightforward question. 🙂

Really terrific question. Thumbs up. 🙂

Well a tough question. Somehow was able to answer but not satisfied. Need to further dive down.

I have yet to work on SQL 2012. So it was very refreshing to learn about one new function through QOTD.

Only if life was that easy... :-):-):-)

Jeff, I had doubt whether we can rollback the truncate only because those data pages deallocated becuase of truncate operation do not get overwrite immediately and hence the second &...

summer_rocks (8/28/2013)

---

JLMayes (8/28/2013)

---

So do you say that the men...

Thanks a lot Gail. Now everything is crystal clear to me on this topic. 🙂

Koen Verbeeck (8/28/2013)

---

craig.schlieve (8/28/2013)

---

Steve,

I am incredibly disappointed in you. This article is disgusting. You are advocating that groups form that will cause fractures in the community to...

L' Eomot/Gail/Jeff/Scott, One more thing to confirm without wasting much of the time. So it means under a transaction, once the truncate is fired against a table, the data pages...