DotNetShoutout

tsql challenges

5
Shouts

Shout it

TSQL Challenge 76 - Identify the sequence of accounting transactions

published 443 days, 8 hours, 32 minutes ago posted by

dhara 452 days, 17 hours, 33 minutes ago

The challenge is to identify the sequence of accounting transactions. The table has data which is ordered. You need to follow the order of the data, and detect a certain condition which lasts for a sequence of data rows, you need to give these data points an ID which uniquely identifies the sequence. T (more)

category: Data | clicked: 67 | 2 comments | | source: beyondrelational.com

tags: SQL Server, tsql challenges, TSQL

9
Shouts

Shout it

TSQL Challenge 70 - Find the longest sequence of alphabets in a string – Part 2

published 521 days, 16 hours, 35 minutes ago posted by

dhara 529 days, 2 hours, 27 minutes ago

This challenge invites you to identify the longest sequence of alphabets from a string. This challenge is Version 2 of the TSQL Challenge 67. The difference is that in this version, you should apply circling while finding the longest sequence. (more)

category: Data | clicked: 15 | comment | | source: beyondrelational.com

tags: SQL Server, tsql challenges, TSQL

7
Shouts

Shout it

TSQL Challenge 69 - Find the most relevant advertisement based on keywords – Part 2

published 546 days, 7 hours, 42 minutes ago posted by

kinj312 549 days, 6 hours, 2 minutes ago

A website wants to display most relevant ads on each of its web pages based on the keywords associated with each page. Your job is to write a TSQL query that returns the advertisements most relevant to each web page given in the source table. This challenge... (more)

category: Data | clicked: 12 | comment | | source: beyondrelational.com

tags: SQL Server, tsql challenges, TSQL

5
Shouts

Shout it

TSQL Challenge 68 - Generate kaprekar kernel or series from numbers

published 560 days, 8 hours, 45 minutes ago posted by

dhara 563 days, 3 hours, 52 minutes ago

This challenge invites you to Generate kaprekar kernel or series from numbers.Kaprekar Series and Kaprekar Constants are numbers generated by applying the Kaprekar Routine on a number! (more)

category: Data | clicked: 3 | comment | | source: beyondrelational.com

tags: SQL Server, tsql challenges, TSQL

7
Shouts

Shout it

TSQL Challenge 66 - Find the most relevant advertisement based on keywords

published 582 days, 6 hours, 14 minutes ago posted by

dhara 585 days, 4 hours, 32 minutes ago

category: Data | clicked: 3 | comment | | source: beyondrelational.com

tags: SQL Server, tsql challenges, Puzzle, TSQL

5
Shouts

Shout it

TSQL Challenge 65 - Solving the Running Total Problem

published 596 days, 14 hours, 26 minutes ago posted by

dhara 598 days, 1 hour, 30 minutes ago

This challenge invites you to solve one of the most common calculation challenges seen in applications that deal with financial transactions. This is not a very complicated challenge and there are different ways to solve this. The key here is to see some... (more)

category: Data | clicked: 17 | 2 comments | | source: beyondrelational.com

tags: SQL Server, tsql challenges, TSQL

8
Shouts

Shout it

TSQL Challenge 64 - A Payroll calculation Challenge

published 609 days, 20 hours, 45 minutes ago posted by

kinj312 618 days, 5 hours, 15 minutes ago

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

category: Data | clicked: 16 | 13 comments | | source: beyondrelational.com

tags: SQL Server, tsql challenges, TSQL

6
Shouts

Shout it

TSQL Challenge 63 - A TSQL Sudoku

published 630 days, 1 hour, 47 minutes ago posted by

dhara 631 days, 15 minutes ago

This challenge is a puzzle of numbers. Everyone of you might have came across this puzzle named 'Sudoku'. (more)

category: Data | clicked: 11 | 3 comments | | source: beyondrelational.com

tags: SQL Server, tsql challenges, TSQL

5
Shouts

Shout it

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

published 646 days, 10 hours, 20 minutes ago posted by

kinj312 647 days, 4 hours, 59 minutes ago

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. (more)

category: Data | clicked: 2 | comment | | source: beyondrelational.com

tags: SQL Server, tsql challenges, TSQL

6
Shouts

Shout it

TSQL Challenge 61 - Generate an HTML calendar in TSQL

published 660 days, 16 hours, 14 minutes ago posted by

dhara 663 days, 4 hours, 51 minutes ago

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... (more)

category: Data | clicked: 49 | comment | | source: beyondrelational.com

tags: SQL Server, tsql challenges, TSQL

5
Shouts

Shout it

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

published 673 days, 16 hours, 29 minutes ago posted by

dhara 674 days, 4 hours, 36 minutes ago

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. (more)

category: Data | clicked: 3 | comment | | source: beyondrelational.com

tags: SQL Server, tsql challenges, TSQL

5
Shouts

Shout it

TSQL Challenge 59 - Playing Chess in TSQL – Part 2

published 680 days, 1 hour, 2 minutes ago posted by

dhara 682 days, 4 hours, 14 minutes ago

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... (more)

category: Data | clicked: 10 | 1 comment | | source: beyondrelational.com

tags: SQL Server, tsql challenges, TSQL

4
Shouts

Shout it

TSQL Challenge 58 - Playing Chess in TSQL – Part 1

published 689 days, 5 hours, 6 minutes ago posted by

dhara 690 days, 5 hours, 7 minutes ago

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... (more)

category: Data | clicked: 5 | comment | | source: beyondrelational.com

tags: SQL Server, tsql challenges, TSQL

5
Shouts

Shout it

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

published 704 days, 23 hours, 39 minutes ago posted by

dhara 707 days, 5 hours, 3 minutes ago

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. (more)

category: Data | clicked: 3 | comment | | source: beyondrelational.com

tags: SQL Server, tsql challenges, TSQL

4
Shouts

Shout it

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

published 728 days, 2 hours, 51 minutes ago posted by

dhara 729 days, 5 hours, 15 minutes ago

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. Your task is to multiply two positive integer strings and return... (more)

category: Data | clicked: 2 | comment | | source: beyondrelational.com

tags: SQL Server, tsql challenges, TSQL

6
Shouts

Shout it

TSQL Challenge 54 - Find the longest matching area code from phone numbers

published 745 days, 11 hours ago posted by

dhara 746 days, 5 hours, 16 minutes ago

An IVR application stores call information into a SQL Server table. A reporting application needs to read phone numbers from the call log and identify the country-code/area-code that is part of the phone number. Your job is to write a query that identifies the longest matching country... (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: SQL Server, tsql challenges, TSQL

6
Shouts

Shout it

TSQL Challenge 53 - Finding empty and non-empty intervals among many start-end intervals

published 759 days, 14 hours, 4 minutes ago posted by

dhara 766 days, 4 hours, 55 minutes ago

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. For the intervals separated by these empty intervals show the maximum number of simultaneous users. Want to... (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: SQL Server, tsql challenges, TSQL

7
Shouts

Shout it

TSQL Challenge 52 - Recursive Wage Calculation in a Parent-Child dimension

published 777 days, 1 hour, 37 minutes ago posted by

dhara 779 days, 4 hours, 59 minutes ago

In a Employee Parent-Child dimension, where each employee has his own identification number and a parent number to his manager. This challenge is intended to calculate company's wage spent below a top level manager. Connect your source control system to SQL Server "I've... (more)

category: Data | clicked: 1 | comment | | source: beyondrelational.com

tags: SQL Server, tsql challenges, TSQL

7
Shouts

Shout it

TSQL Challenge 51 - Convert long Binary strings to Decimal strings

published 795 days, 15 hours ago posted by

dhara 798 days, 4 hours, 27 minutes ago

TSQL Challenge 40 challenged you to a query that converts binary values into hexadecimal format. This challenge invites you to write a query that converts binary values into decimal format. The tough part with this challenge is that the input strings can be up to 2048 characters long... (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: SQL Server, tsql challenges, TSQL

6
Shouts

Shout it

TSQL Challenges is turning 2 years old!

published 806 days, 3 minutes ago posted by

kinj312 807 days, 5 hours, 56 minutes ago

This week is very special for us because TSQL Challenges is turning 2 years old by the end of this week. The first TSQL Challenge was published on the last week of February 2009 and this week we published TSQL Challenge 50 . In the last two years, we have learned quite a lot of stuff from our mistakes... (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: SQL Server, tsql challenges, TSQL

Welcome!

tsql challenges

TSQL Challenge 76 - Identify the sequence of accounting transactions

TSQL Challenge 70 - Find the longest sequence of alphabets in a string – Part 2

TSQL Challenge 69 - Find the most relevant advertisement based on keywords – Part 2

TSQL Challenge 68 - Generate kaprekar kernel or series from numbers

TSQL Challenge 66 - Find the most relevant advertisement based on keywords

TSQL Challenge 65 - Solving the Running Total Problem

TSQL Challenge 64 - A Payroll calculation Challenge

TSQL Challenge 63 - A TSQL Sudoku

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

TSQL Challenge 61 - Generate an HTML calendar in TSQL

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

TSQL Challenge 59 - Playing Chess in TSQL – Part 2

TSQL Challenge 58 - Playing Chess in TSQL – Part 1

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

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

TSQL Challenge 54 - Find the longest matching area code from phone numbers

TSQL Challenge 53 - Finding empty and non-empty intervals among many start-end intervals

TSQL Challenge 52 - Recursive Wage Calculation in a Parent-Child dimension

TSQL Challenge 51 - Convert long Binary strings to Decimal strings

TSQL Challenges is turning 2 years old!

Open ID Login

Standard Login

Forgot Password?

Sign up