Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
Regular Columnist: Jacob Sebastian
SQLServerCentral.com profile
Items 1 to 20 of 91
Next 20 >>
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,377 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
|
563 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,365 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
|
651 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-sqlchallenges
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
1,511 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-sqlchallenges
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
1,197 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-sqlchallenges
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
855 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,488 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,261 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
|
909 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
|
572 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
|
834 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
|
869 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
|
536 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,521 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 challenge
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
1,211 reads
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,724 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,136 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,676 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
|
882 reads
Items 1 to 20 of 91
Next 20 >>
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.