Solution to TSQL Beginners Challenge 6...

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

Solution to TSQL Beginners Challenge 5...

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

Solution to TSQL Beginners Challenge 4...

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

Solution to TSQL Beginners Challenge 3...

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

Solution to TSQL Beginners Challenge 1...

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