Code Samples
The following is a selection of 5 of my submissions to T-SQL Challenges hosted by BeyondRelational.com. Although the challenges below do not always mirror real life situations, the skills and coding techniques that they demonstrate display an understanding of TSQL and problem solving that I believe makes them perfect for this. For each of the following Challenges, there are three links:
The original challenge link will take you to a page describing the problem and all the restrictions the code was written to overcome. The ‘My Solution’ link is my solution to that challenge. The Solution sandbox is my solution to the challenge along with some sample data so you can copy/paste/run the whole thing in SSMS to see the results. Note: All of the following examples require SQL 2005 or 2008 to run.
Reading, recognizing and processing graphical representation of digits.
| Original Challenge | My Solution | Solution Sandbox |
Identify repeating digits in Fibonacci Series
| Original Challenge | My Solution | Solution Sandbox |
Working with consolidated calculations on hierarchical structures
| Original Challenge | My Solution | Solution Sandbox |
Generate text formatted month calendars
| Original Challenge | My Solution | Solution Sandbox |
Find discrepancies in the scheduled activities and actual activities performed by employees
| Original Challenge | My Solution | Solution Sandbox |