|
|
-
Created 3 Years ago
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".
|
-
Created 3 Years ago
This challenge involves finding available registration dates based on event schedules and registration data.
|
-
Created 3 Years ago
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.
|
-
Created 3 Years ago
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.
|
-
Created 3 Years ago
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.
|
-
Created 3 Years ago
There are two tables involved in this challenge. The first table is MovieReleaseDates which will contain the names of movies along with their release dates.
|
-
Created 3 Years ago
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
|
-
Created 3 Years ago
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.
|
-
Created 3 Years ago
This challenge has been taken from a forum. The challenge is all about searching the closest number in a collection of numbers. Let’s have a look into the sample data.
|
-
Created 3 Years ago
This challenge has been seen in one of the SQL Server forums. The challenge is all about merging the data based on certain conditions.
|