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

   Items 1 to 20 of 72    Older >>
 

TSQL Challenge 83 - Compare rows in the same table and group the data

The challenge is to compare the data of the rows and group the input data. The data needs to be grouped based on the Product ID, Date, TotalLines, LinesOutOfService.   Read more...
By Jacob Sebastian 2012/10/08 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: |  Discuss |   Briefcase | 1,574 reads

TSQL Challenge 82 - Find elements that uniquely make up a group

The challenge is to find the Tax Code based on Price. Each sales amount is uniquely made up by the sum of one or more prices. Based on this you should assign the tax code to each price.   Read more...
By Jacob Sebastian 2012/09/17 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: |  Discuss |   Briefcase | 1,175 reads

TSQL Challenge 81 - Create a Game schedule generator in TSQL

This challenge is to generate a game scheduler based on the Teams given in a table.   Read more...
By Jacob Sebastian 2012/07/04 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: (not yet rated) |  Discuss |   Briefcase | 1,390 reads

TSQL Challenge 80 - Find the minimal set of intervals without gaps

The challenge is to find the minimal set of intervals without creating gaps.  Read more...
By Jacob Sebastian 2012/04/16 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: (not yet rated) |  Discuss |   Briefcase | 1,460 reads

TSQL Challenge 79 - Finding the Islands

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

TSQL Challenge 78 - Parse single field into multiple fields

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...
By Jacob Sebastian 2012/03/19 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: |  Discuss |   Briefcase | 2,475 reads

TSQL Challenge 77-Transform monthly resource efforts to weekly actuals

The challenge is to transform monthly resource efforts into weekly actuals.  Read more...
By Jacob Sebastian 2012/03/05 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: (not yet rated) |  Discuss |   Briefcase | 671 reads

TSQL Challenge 76 - Identify the sequence of accounting transactions

The challenge is to identify the sequence of accounting transactions.   Read more...
By Jacob Sebastian 2012/02/20 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: (not yet rated) |  Discuss |   Briefcase | 1,566 reads

TSQL Challenge 75 - Find the Episode and Sequence based on interval

The challenge is to find the Episode and Sequence based on interval.   Read more...
By Jacob Sebastian 2012/02/06 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: (not yet rated) |  Discuss |   Briefcase | 1,232 reads

TSQL Challenge 74 - Find the expiring quantity of material

The challenge is to create a query for a report that show expiring material  Read more...
By Jacob Sebastian 2012/01/23 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: (not yet rated) |  Discuss |   Briefcase | 872 reads

TSQL Challenge 73 - Implement Word Wrapping in TSQL

The challenge is to wrap the text by specified position.   Read more...
By Jacob Sebastian 2012/01/09 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: (not yet rated)  Rate this |   Briefcase | 2,610 reads

TSQL Challenge 72 - Calculate the Payroll Hours of Employees

This challenge invites you to solve a payroll challenge which requires to calculate the number of hours employee worked in a week.  Read more...
By Jacob Sebastian 2011/12/26 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: (not yet rated) |  Discuss |   Briefcase | 1,646 reads

TSQL Challenge 71 - Play mangled words game in TSQL

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

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

This challenge invites you to identify the longest sequence of alphabets from a string.  Read more...
By Jacob Sebastian 2011/11/28 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: (not yet rated) |  Discuss |   Briefcase | 936 reads

TSQL Challenge 69 - Find the most relevant advertisement based on keyw

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

TSQL Challenge 68 - Generate kaprekar kernel or series from numbers

This challenge invites you to Generate kaprekar kernel or series from numbers.  Read more...
By Jacob Sebastian 2011/10/31 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: (not yet rated) |  Discuss |   Briefcase | 854 reads

TSQL Challenge 67 - Find the longest sequence of alphabets in a string

This challenge invites you to identify the largest sequence of alphabets from a string.  Read more...
By Jacob Sebastian 2011/10/17 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: (not yet rated) |  Discuss |   Briefcase | 894 reads

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

A website wants to display most relevant ads on each of its web pages based on the keywords associated with each page.   Read more...
By Jacob Sebastian 2011/10/03 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: (not yet rated) |  Discuss |   Briefcase | 541 reads

TSQL Challenge 65 - Solving the Running Total Problem

This challenge invites you to solve one of the most common calculation challenges seen in applications that deal with financial -transactions.  Read more...
By Jacob Sebastian 2011/09/19 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: (not yet rated) |  Discuss |   Briefcase | 1,590 reads

TSQL Challenge 64 - A Payroll calculation Challenge

This challenge invites you to solve a payroll challenge which requires special calculation of holidays and absences that are adjacent to holidays  Read more...
By Jacob Sebastian 2011/09/05 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: (not yet rated) |  Discuss |   Briefcase | 1,289 reads
   Items 1 to 20 of 72    Older >>