Database Challenges

TSQL Challenge 64 - A Payroll calculation Challenge

This challenge invites you to solve a payroll challenge which requires special calculation of holidays and absences that are adjacent to holidays.

TSQL Challenge 63 - A TSQL Sudoku

This challenge is a puzzle of numbers. Everyone of you might have came across this puzzle named 'Sudoku'. I usually see it in the daily Newspaper. The puzzle is just a play of numbers from 1 to 9, arranging them in nine boxes in an order such that each number from 1 to 9 exists in each box, column and row.

TSQL Challenge 62 - Break a long sentence in groups of 5 words

Read the input string and break each sentence into groups of 5 words. A row may contain more than one sentence. Each sentence in the input should start a new group.

TSQL Challenge 61 - Generate an HTML calendar in TSQL

This challenge is to generate an HTML calendar based on the data stored in a table. The concept is very similar to the calendar we generate for the Quiz Series.

TSQL Challenge 60 - Generate a relational tree structure from a string

An ETL application receives product and category information in a text file. The category hierarchy is specified as a string. Your job is to read the hierarchy information and generate a relational table (result set) representing the hierarchy of categories.

TSQL Challenge 59 - Playing Chess in TSQL – Part 2

This is a continuation of the previous challenge where we generated a TSQL representation of a chess board filled with pieces based on input strings in Forsyth-Edwards Notation. This challenge invites you to perform a bit more complicated operation.

TSQL Challenge 58 - Playing Chess in TSQL – Part 1

Let us play Chess with TSQL in this challenge. The input table contains strings that represent the layout of chess boards filled with pieces using Forsyth-Edwards Notation.

Your job is to read the input string and generate a result set that represents the position of pieces in a chess board.

TSQL Challenge 57 - Identify rows that match the rollup trade data

This challenge is related to calculations used in stock markets and the original idea was found in one of the SQL forums.

Your job is to scan the trades data and identify combination of trades that match a given rollup data. The sample input data for this puzzle is given below.

TSQL Challenge 56 - Create a Sierpinski carpet using TSQL

This challenge invites you to generate a Sierpinsky carpet using TSQL. If you are new to Sierpinsky Carpet, see the details here (http://en.wikipedia.org/wiki/Sierpinski_carpet).

Your job is to read the input table and generate a Sierpinsky carpet of the specified level. The sample input data for this puzzle is given below.

TSQL Challenge 55 - Multiply two very long decimal strings and return the product

We recently saw a number of challenges that deal with Binary, Decimal and Hexadecimal strings (TSQL Challenge 40 and 51). Here is yet another challenge that deals with Decimal strings, but presents a different problem.