TSQL Beginners Challenge 13 - Validate GUID values and perform a horizontal and vertical count of characters

The challenge involves validating the GUID values and perform horizontal and vertical count of the characters "1, 2, 3, 4, 5, A, B, C, D, E". The definition of valid GUID is "The GUID value should contain all the characters 1, 2, 3, 4,...

TSQL Beginners Challenge 9 - Find the Parents and Adjacent Members of the Node

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

TSQL Beginner’s Challenge #1 – Find the second highest salary for each department

Well, we have been talking about the beginner’s version of TSQL Challenges for quite some time. We received a number of emails asking for the ETA of TSQL Beginners Challenges. Finally, we are ready to go and I am very glad to make the announcement for...