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

Solution to TSQL Beginners Challenge 22...

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

Solution to TSQL Beginners Challenge 21...

Solution to TSQL Beginners Challenge 22...

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

Solution to TSQL Beginners Challenge 22...