TSQL Challenges for Beginners

TSQL Beginners Challenge 15 - Reverse the order of words within a sentence

This challenge is to reverse the order of words within a sentence. Most of us must be familiar with reversing the order of letters within a word. This challenge invites you to take a sentence and reverse the order of words within it. For example, if the...

by Niladri Biswas on 08-30-2010 | 301 Views

TSQL Beginners Challenge 14 - Count the number of occurrence of characters in the string

This challenge is all about counting the number of occurrence of characters in a string using a SET based query. The task is to list all the characters and count of that character within the given string Here is the sample data for this challenge Data...

by Niladri Biswas on 08-16-2010 | 917 Views

Announcing winners of TSQL Beginners Challenge 2

We just completed the evaluation of TSQL Beginner's Challenge 2 - Fight Your Fear for Date Calculations . The results of the evaluation process is found at: TSQL Beginners Challenge 2 – All Submissions TSQL Beginners Challenge 2 – Accepted Submissions...

by JacobSebastian on 08-05-2010 | 174 Views

TSQL Beginners Challenge 13 - Validate GUID values and perform a horizontal and vertical count of characters

The challenge involves validating the GUID values and perform horizontal and vertical count of the characters "1, 2, 3, 4, 5, A, B, C, D, E". The definition of valid GUID is "The GUID value should contain all the characters 1, 2, 3, 4,...

by Niladri Biswas on 08-02-2010 | 935 Views

TSQL Beginners Challenge 12 - Find the available registration dates

This challenge involves finding available registration dates based on event schedules and registration data. Students can register for an event only for a specific period defined in "tblRegistration" table. Another table callled "tblEvent"...

by Niladri Biswas on 07-19-2010 | 1,010 Views

Announcing winners of TSQL Beginners Challenge 1

It took us a while to setup the evaluation process and start with the evaluations. We have been working hard on catching up with the pending evaluation work in the TSQL Challenges for the last several months and it is time for us to come back to the beginners...

by Jacob Sebastian on 07-16-2010 | 225 Views

TSQL Beginners Challenge 11 - Find three most recent builds of each application from XML log

This challenge involves reading information from XML columns. The table keeps track of the progressive builds of an application in a development environment and your task is to identify the most recent 3 builds of each application. Results should be sorted...

by Niladri Biswas on 07-05-2010 | 613 Views

TSQL Beginners Challenge 10 - Clean up alphanumeric strings by splitting digits and letters into separate columns

This challenge refers to sanitizing text data. Your task is to read an alphanumeric string and create two output columns one containing all the digits found in the input string and the other with all the letters of the English Alphabet. Sample Input Data...

by Niladri Biswas on 06-20-2010 | 1,177 Views

TSQL Beginners Challenge 9 - Find the Parents and Adjacent Members of the Node

This challenge refers to a real-world problem I came across recently. The requirement was to identify all 'direct' or 'indirect' parents of a given child node and all its siblings....

by Niladri Biswas on 06-06-2010 | 860 Views

TSQL Beginners Challenge 8 - Identify the release dates of movies on different cities

The Challenge Let us one again play with a date related problem. The challenge is to identify the various movies released in cities. There are two tables involved in this challenge. The first table is MovieReleaseDates which will contain the names of...

by Niladri Biswas on 05-24-2010 | 859 Views

TSQL Beginners Challenge 7 - Count the occurrence of numbers in the Palindrome Primes

Challenge Context This challenge is to test the logical ability and does not have any resemblance with real time problem. The task is to generate the palindrome primes from 10 to 1000 and count the number of occurrences of each digit in them A number...

by Niladri Biswas on 05-10-2010 | 671 Views

TSQL Beginners Challenge 6 - Count the number of mobile phones and generate a summary

This challenge aims to test your string parsing and summarizing skills using TSQL. The challenge is to count the number of mobile phones each person has and generate a summary row....

by Niladri Biswas on 04-26-2010 | 790 Views

TSQL Beginners Challenge 5 - Search the closest number in the series

This challenge has been taken from a forum. The challenge is all about searching the closest number in a collection of numbers....

by Niladri Biswas on 04-12-2010 | 829 Views

TSQL Beginners Challenge 4 - Concatenating values from multiple rows

This is a TSQL Challenge for the beginners. The challenge involving writing a query that concatenates values from multiple rows using a single SELECT query....

by Niladri Biswas on 03-28-2010 | 1,056 Views

TSQL Beginners Challenge 3 - Find the Factorial

The Challenge This challenge though does not have any resemblance with the real time problem directly, but it measures about logical thinking. The problem is all about finding the factorial of numbers. Though it is known to most of us what a factorial...

by Niladri Biswas on 03-15-2010 | 1,021 Views