Regular Columnist: Jacob Sebastian

This challenge invites you to play Sudoku in TSQL  Read more...

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

This challenge is to generate an HTML calendar based on the data stored in a table.   Read more...

Your job is to read a string containing product hierarchy information and generate a relational table (result set) representing the hierarchy of categories.  Read more...

Your job is to generate a string using Forsyth-Edwards Notation which represents the final position of pieces after performing a series of moves from the original position  Read more...

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

Your job is to scan the trades data and identify combination of trades that match a given rollup data.  Read more...

This challnge invites you to generate a Sierpinsky carpet using TSQL  Read more...

This challenge to multiply two positive integer strings and return their product. The strings can be really long: up to 1024 digits  Read more...

Your job is to write a query that identifies the longest matching country/area code from each phone number based on the information stored in an area-code reference table.  Read more...

A SQL Server instance is set up to log the session start time and end time into a table. Given this table, your job is to find all time intervals in which no one is logged in.  Read more...

This challenge is intended to calculate company's wage spent below a top level manager.  Read more...

This challenge invites you to write a query that converts binary values into decimal format.  Read more...

The purpose of this challenge is to test your query writing skills with a limited set of TSQL keywords.   Read more...

Several technicians are sent to a customer premises to do a certain maintenance work. Your task is to process the activity log entered by each technician and identify overlaps.  Read more...

This challenge is to parse and evaluate arithmetic expressions using TSQL.  Read more...

A table contains the list of modifications made to each card. Your job is to write a query that shows the first number, current number (most recent) and the number of changes made.  Read more...

This challenge is a slightly enhanced version of the ‘remove leading zeros’ problem  Read more...

This challenge involves evaluating mathematical expressions presented using Roman Numerals and return the result of each expression.  Read more...

The first part of your job is to identify the unique color combinations of products and the second part is to identify the products that have the given color combination.  Read more...