Before making the move I would recommend using the update advisor to see how much work or problems that I might have

http://msdn.microsoft.com/en-us/library/ms144256.aspx

Try here: Redgate the sponsors/owners probably have some product that will meet your needs.

http://www.red-gate.com/our-company/about/entrypage/welcome-ssc-visitors?utm_source=ssc&utm_medium=textad&utm_campaign=ssclandingpage

Missed what is the suposed correct answer. Got confused - I looked at the execution plan ... did NOT consider the message tab as part of the execution plan...

In the 1965-1970 time frame data base gradually evolved to the now current useage database.

Assume it is the median value that has you stumped, try reading this, it works for myself.

http://www.mssqltips.com/sqlservertip/2523/script-to-calculate-the-median-value-for-sql-server-data/?utm_source=dailynewsletter&utm_medium=email&utm_content=headline&utm_campaign=20111030

This is most likely what you want and need

http://msdn.microsoft.com/en-us/library/ms144256(v=sql.100).aspx

Sounds like a homework question .. in case it is NOT ... please post the table definition(s), sample data and required results.

You can do this quickly and very easily..... click...

L' Eomot Inversé (1/12/2013)

---

Nice clear straightforward question.

Good to see a question on this new feature.

Interestingly, there's an error on the BoL page: it says the CHOOSE function

BoL

---

Returns...

L' Eomot Inversé

Actually, just to create some discord, I think the question is far too easy. And I'm appalled that 23 people out of 1210 got it wrong; but looking...

Thanks - so use to...

Nice back to basics question ..................... thanks

Kind of sad when the author of a published QOD can not find a Microsoft page to justify the correct answer to the question.

So here it is:

http://msdn.microsoft.com/en-us/library/ms190764(v=sql.105).aspx

I thought the explanation...

In order to receive a rapid answer to your question, it is beholden on you to present your table definition(s), sample data and required answer(s), in a readily consumable format....

Steve Jones - SSC Editor (12/21/2012)

---

Happy holidays, everyone and hope you enjoy the rest of the year. This is my last workday in 2012, though I'll be checking in here...