Great article. However, personallly I wouldn't use column numbers in the order by clause. It's a bit of a bad habit in my opinion and can cause issues later on...
Thanks. This is very useful information. Just on your company's overstrict policy on forums. Forum discussions are an essential tool for DBAs, heck, IT staff in general. It's a necessity....
None of the answers is correct. Choose is a 2012 function, so it doesn't work in 2008 R2, which is the *assumed* SQL version here. Nowhere in the question do...