Regular Columnist: Jacob Sebastian

The challenge is to find the minimal set of intervals without creating gaps.  Read more...

The challenge is to find the Islands(gaps) in sequential dates. You need to write a query to identify continuous intervals from the start date and end date.   Read more...

The database field contains long string with data for Quantity and Parts. The challenge is to parse the data into separate (Quantity and Parts) fields for displaying in a report.   Read more...

The challenge is to transform monthly resource efforts into weekly actuals.  Read more...

The challenge is to identify the sequence of accounting transactions.   Read more...

The challenge is to find the Episode and Sequence based on interval.   Read more...

The challenge is to create a query for a report that show expiring material  Read more...

This challenge invites you to solve a payroll challenge which requires to calculate the number of hours employee worked in a week.  Read more...

Your task is to process the input table that contains several mangled words and try to 'un-mangle' them and validate them against a 'dictionary' table.  Read more...

This challenge invites you to identify the longest sequence of alphabets from a string.  Read more...

Your job is to write a TSQL query that returns the advertisements most relevant to each web page given in the source table.  Read more...

This challenge invites you to Generate kaprekar kernel or series from numbers.  Read more...

This challenge invites you to identify the largest sequence of alphabets from a string.  Read more...

A website wants to display most relevant ads on each of its web pages based on the keywords associated with each page.   Read more...

This challenge invites you to solve one of the most common calculation challenges seen in applications that deal with financial -transactions.  Read more...

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

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