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

Thanks Rami! Now do we have a deadline? I need at least a week to read and understand the problem and a month or two to solve....

Two quick questions, What is the submission cutoff date/time for Challenge #20? I understand the a number like 1234412344123 would count as 1 repeating sequence, but what about 12344123444123? Does 44 and 444 count as 1 or two? Thanks, Steve