Database Migration, Comparision and Synchronization Tools
Got a SQL Server or .NET question? Discuss it in the forums. (SQL Server Forums | Dot NET Forums)
First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.

TSQL Challenge 34 - Search for two keywords within the maximum distance of one word between them

This challenge is all about searching for two keywords in a string with a maximum distance of 'one word' between them. For example, if 'sql' and 'server' are the keywords, a match will be found on 'Microsoft SQL Server 2008'...
Posted: 07-12-2010 1:13 AM by JacobSebastian
Filed under: , , , , ,

Logic Testing Data for TSQL Challenge 17

We are about to start the logic testing of TSQL Challenge 17 . The tricky data for this challenge is published at http://databasechallenges.com/SQLServer/TSQL/Challenge17/logic_testing . We would like to request everyone to take a look at the logic testing...
Posted: 02-27-2010 8:35 PM by Jacob Sebastian | with 1 comment(s)
Filed under: , , , , , , ,

TSQL Challenge 21 - Reading, recognizing and processing graphical representation of digits.

Here is a challenge that takes you away from those repetitive boring type of queries that you write over and over again, several times a day. All of us, the database people, are familiar with thinking in set based manner as well as row by row style. Here...
Posted: 01-11-2010 1:00 AM by Rui Carvalho | with 66 comment(s)
Filed under: , , ,

TSQL Challenge 20 - Identify repeating digits in Fibonacci Series

This challenge has absolutely no relevance to a real-life problem, but it is very interesting because it tests your programming skills and abstract thinking. The Fibonacci series is defined as 1, 1, 2, 3, 5, 8, 13, 21, 34, 55 etc, where each number in...
Posted: 12-27-2009 5:01 PM by Rui Carvalho | with 63 comment(s)
Filed under: , , ,

TSQL Challenge 19 - Working with consolidated calculations on hierarchical structures

Working with hierarchies is almost always lot of fun for most of us. Traversing heirarchies and processing data from child or parent nodes is really interesting and such assignments are ideal opportunities to test your logic and query writing skills....
Posted: 12-14-2009 1:50 AM by Rui Carvalho | with 10 comment(s)
Filed under: , , ,

TSQL Challenge 18 - Generate text formatted month calendars

This is the first time we are coming up with a true calendar puzzle. Brad Schulz from TSQL Challenges Team has come up with a very interesting challenge which is all about generating calendars for given number of months. While the real-world application...
Posted: 11-30-2009 1:00 AM by Rui Carvalho | with 45 comment(s)
Filed under: , , ,

TSQL Challenge 13 – Solution by Neeraj Mathur and other TSQL Heros

Introducing new testing levels with complex (tricky) data In the previous post , I had mentioned about the new (improved) evaluation process for the challenges. Brad Schulz is working very hard on leading the process to build the data (which I call ‘tricky...
Posted: 11-27-2009 6:37 AM by Jacob Sebastian | with 1 comment(s)
Filed under: , , ,

TSQL Challenge 13 – Solution by Isham Hamin

Better and Stronger Evaluation Process One of the challenges we, The TSQL Challenge Team has, is to come up with a robust evaluation process. As we dig deeper and deeper into it, we realize that it is not as easy as we thought. We need to come up with...
Posted: 11-26-2009 8:48 PM by Jacob Sebastian | with no comments
Filed under: , , ,

TSQL Challenge 13 – Winning Solution by Jim Carter

We had a glitch in one of the automatic scripts that we use to evaluate the solutions and had to re-evaluate the solutions last night. After spending the whole night (and unlimited cups of coffee) evaluating and reviewing the different solutions, we have...
Posted: 11-25-2009 6:44 AM by Jacob Sebastian | with no comments
Filed under: , ,

TSQL Challenge 16 - Find intersections in date ranges and concatenate aggregated labels

Challenge Context This challenge is derived from a real scenario discussed in a forum. It mainly deals about finding intersections in date ranges. The original source of data will be a table of persons with their member ship: Description StartDate EndDate...
Posted: 11-02-2009 8:47 PM by Rui Carvalho | with 5 comment(s)
Filed under: , , ,

TSQL Challenge 15 - matching data between rows and columns

This challenge is derived from a realistic reporting scenario that requires the transformation of rows into columns. This is commonly known as a matrix, pivot, or crosstab query. This challenge involves two primary tables @Row and @Cols. The objective...
Posted: 10-19-2009 9:49 AM by Adam Haines | with 12 comment(s)
Filed under: , , ,

TSQL Challenge #12 - Build sequential ranges of dates with propagation to missing values

The News Here we go again with a new challenge, we hope that you will have some time to share with us working on the challenge even if it’s summer time. The TSQL Challenge teams are growing and we are very exited to have four new Sql Server MVPs...
Posted: 08-09-2009 3:13 AM by Rui Carvalho | with 3 comment(s)
Filed under: , , ,

TSQL Challenge 9 – Solution by Syed Mehroz Alam

For the TSQL Challenge #9, Syed Mehroz Alam is again part of the winners. You can see its previous solutions for the TSQL Challenge #7 and TSQL Challenge #8 . Syed Mehroz Alam, living in Karachi, Pakistan, is primarily a developer focusing Microsoft technologies...
Posted: 07-30-2009 5:22 AM by Rui Carvalho | with no comments
Filed under: , , , , , , ,

TSQL Challenges - All In One Overview

TSQL Challenges are growing every day and we have now a lot of valuable information produced by our challengers. It is not always easy to have a global idea of what we done in the past and that's the target of this overview page. It is also the opportunity...
Posted: 07-18-2009 7:18 PM by Rui Carvalho
Filed under: , ,

TSQL Challenge 11 – Calculate the lowest price of an Item by applying the best combination of discount coupons

We hope you enjoyed the previous challenge and it is time to look at the next challenge. We are very excited to introduce TSQL Challenge #11, which we think all of you will enjoy solving. Just like we did with the previous challenge, there will be a FREE...
Posted: 07-15-2009 6:55 PM by Rui Carvalho | with 12 comment(s)
Filed under: , , ,
More Posts Next page »

Copyright © Beyondrelational.com