Thanks Ron for another one on SS 2012.
Though I understood the CHOOSE function well, but have to query Employee table to get the answer correctly.
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions
Link to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter