Simple solution with 2 inner join, not very elegant but works at least on SQL 2008....

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 is to test the logical ability and does not have any resemblance with real time problem. The task is to generate the palindrome primes from 10 to 1000 and count the number of occurrences of each digit in them...

There are two tables involved in this challenge. The first table is MovieReleaseDates which will contain the names of movies along with their release dates....

This challenge refers to a real-world problem I came across recently. The requirement was to identify all 'direct' or 'indirect' parents of a given child node and all its siblings....

This challenge refers to sanitizing text data. Your task is to read an alphanumeric string and create two output columns one containing all the digits found in the input string and the other with all the letters of the English Alphabet. ...

This challenge involves reading information from XML columns. The table keeps track of the progressive builds of an application in a development environment and your task is to identify the most recent 3 builds of each application....

This challenge involves finding available registration dates based on event schedules and registration data....