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. ...

Solution to TSQL Beginners Challenge 23...

Many of you must have played the 'mangled words' game in the school. Here is a challenge that gives you an opportunity to play it once again using TSQL....

Solution to TSQL Beginners Challenge 20...

Here is a TSQL challenge to build a well formed HTML fragment from a comma separated list of HTML tags provided as input....

Solution to TSQL Beginners Challenge 19...

This challenge involves counting the number of occurrences of HTML tags in a given list of strings. You can assume that there will be only valid HTML tags in the input strings. The output should display tags in ascending order....

Solution to TSQL Beginners Challenge 18...

This problem is all about identifying all the employees directly or indirectly to whom the given Employee reports to. The challenge is to write a query that can take a Employee Id as a parameter and list all the employees to whom the Employee is reporti...