Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag T-SQL Challenges Rss

Search for any content tagged t-sql challenges

<< Newer    Items 21 to 40 of 72    Older >>
 

TSQL Challenge 63 - A TSQL Sudoku

This challenge invites you to play Sudoku in TSQL  Read more...
By Jacob Sebastian 2011/08/22 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: |  Discuss |   Briefcase | 1,790 reads

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

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...
By Jacob Sebastian 2011/08/08 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: (not yet rated) |  Discuss |   Briefcase | 1,181 reads

TSQL Challenge 61 - Generate an HTML calendar in TSQL

This challenge is to generate an HTML calendar based on the data stored in a table.   Read more...
By Jacob Sebastian 2011/07/25 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: (not yet rated) |  Discuss |   Briefcase | 1,753 reads

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

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...
By Jacob Sebastian 2011/07/11 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: (not yet rated) |  Discuss |   Briefcase | 927 reads

TSQL Challenge 59 - Playing Chess in TSQL – Part 2

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...
By Jacob Sebastian 2011/06/27 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: (not yet rated) |  Discuss |   Briefcase | 801 reads

TSQL Challenge 58 - Playing Chess in TSQL – Part 1

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...
By Jacob Sebastian 2011/06/13 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: (not yet rated) |  Discuss |   Briefcase | 1,655 reads

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

Your job is to scan the trades data and identify combination of trades that match a given rollup data.  Read more...
By Jacob Sebastian 2011/05/30 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: (not yet rated) |  Discuss |   Briefcase | 851 reads

TSQL Challenge 56 - Create a Sierpinski carpet using TSQL

This challnge invites you to generate a Sierpinsky carpet using TSQL  Read more...
By Jacob Sebastian 2011/05/16 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: (not yet rated) |  Discuss |   Briefcase | 2,484 reads

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

This challenge to multiply two positive integer strings and return their product. The strings can be really long: up to 1024 digits  Read more...
By Jacob Sebastian 2011/05/02 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: (not yet rated) |  Discuss |   Briefcase | 1,252 reads

TSQL Challenge 54 - Find the longest matching area code

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...
By Jacob Sebastian 2011/04/18 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: (not yet rated) |  Discuss |   Briefcase | 1,147 reads

TSQL Challenge 53 - Finding empty and non-empty intervals

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...
By Jacob Sebastian 2011/04/04 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: (not yet rated) |  Discuss |   Briefcase | 1,492 reads

TSQL Challenge 52: Recursive Wage Calculation in a Parent-Child dimens

This challenge is intended to calculate company's wage spent below a top level manager.  Read more...
By Jacob Sebastian 2011/03/21 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: (not yet rated) |  Discuss |   Briefcase | 1,589 reads

TSQL Challenge 51 - Convert long Binary strings to Decimal strings

This challenge invites you to write a query that converts binary values into decimal format.  Read more...
By Jacob Sebastian 2011/03/07 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: (not yet rated) |  Discuss |   Briefcase | 6,659 reads

TSQL Challenge 50 - Extracting a specifical range from random data wit

The purpose of this challenge is to test your query writing skills with a limited set of TSQL keywords.   Read more...
By Jacob Sebastian 2011/02/21 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: (not yet rated) |  Discuss |   Briefcase | 1,684 reads

TSQL Challenge 49 - Identify overlapping time sheet entries of field t

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...
By Jacob Sebastian 2011/02/07 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: (not yet rated) |  Discuss |   Briefcase | 1,375 reads

TSQL Challenge 48 - Parse and evaluate Arithmetic Expressions using TS

This challenge is to parse and evaluate arithmetic expressions using TSQL.  Read more...
By Jacob Sebastian 2011/01/24 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: |  Discuss |   Briefcase | 2,235 reads

TSQL Challenge 47 - Read the modification history and identify the fir

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...
By Jacob Sebastian 2011/01/10 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: (not yet rated) |  Discuss |   Briefcase | 928 reads

TSQL Challenge 46 - Remove leading occurrences of the first character

This challenge is a slightly enhanced version of the ‘remove leading zeros’ problem  Read more...
By Jacob Sebastian 2010/12/27 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: (not yet rated) |  Discuss |   Briefcase | 1,684 reads

TSQL Challenge 45 - Evaluate mathematical expressions presented using

This challenge involves evaluating mathematical expressions presented using Roman Numerals and return the result of each expression.  Read more...
By Jacob Sebastian 2010/12/13 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: (not yet rated) |  Discuss |   Briefcase | 1,638 reads

TSQL Challenge 44 – Identify products that belong to each unique color

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...
By Jacob Sebastian 2010/11/29 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: (not yet rated) |  Discuss |   Briefcase | 1,315 reads
<< Newer    Items 21 to 40 of 72    Older >>