The challenge is to find the employees with the second highest salary in each department. However, it is a little more complicated because if two employees have the same salary, you need to list both of them.

The challenge is to implement similarly functionality in TSQL, that works similar to TRANSLATE function of ORACLE.

This challenge though does not have any resemblance with the real time problem directly, but it measures about logical thinking. The problem is all about finding the factorial of numbers

This challenge deals with String aggregation. On occasion it is necessary to aggregate data from a number of rows into a single row, giving a list of data associated with a specific value.

This challenge is to reverse the order of words within a sentence.

This challenge has been seen in one of the SQL Server forums. The challenge is all about merging the data based on certain conditions.

This challenge has been taken from a forum. The challenge is all about searching the closest number in a collection of numbers. Let’s have a look into the sample data.

This challenge aims to test your string parsing and summarizing skills using TSQL. The challenge is to count the number of mobile phones each person has and generate a summary row.

This challenge to is implement similarly functionality in TSQL, that works similar to INITCAP function of ORACLE.

This challenge is to find the date based on year, month, day of the week and weekday number. Say for example, if the question is to find the date of 2nd Sunday of January 2010, the answer should be '2010-01-10'.