
Moved to : http://beyondrelational.com/modules/19/tsqlbeginners/326/tsqlbeginnerschallenge13validateguidvaluesandperformahorizontalandverticalcount.aspx?tab=info

This challenge is all about searching for two keywords in a string with a maximum distance of 'one word' between them.. http://beyondrelational.com/puzzles/challenges/38/searchfortwokeywordswithinthemaximumdistanceofonewordbetweenthem.aspx

Moved to http://beyondrelational.com/modules/19/tsqlbeginners/309/tsqlbeginnerschallenge9findtheparentsandadjacentmembersofthenode.aspx?tab=info

I have received a number of requests for an explanation of my winning query of TSQL Challenge 19 . This involved traversing a hierarchy of employees and rolling a count of orders from subordinates up to superiors. The first concept I shall address is the hierarchyId , which is constructed within the...

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 data and the expected results and see if you...

This challenge is related to Reading, recognizing and processing graphical representation of digits. http://beyondrelational.com/puzzles/challenges/25/readingrecognizingandprocessinggraphicalrepresentationofdigits.aspx

This challenge is to Identify repeating digits in Fibonacci Series. http://beyondrelational.com/puzzles/challenges/24/identifyrepeatingdigitsinfibonacciseries.aspx

This challenge is related to Work with consolidated calculations on hierarchical structures. http://beyondrelational.com/puzzles/challenges/23/workingwithconsolidatedcalculationsonhierarchicalstructures.aspx

This is a challenge to Generate text formatted month calendars. http://beyondrelational.com/puzzles/challenges/22/generatetextformattedmonthcalendars.aspx

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 and interesting data’ but he prefers to call...

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 better and stronger evaluation process to make sure...

We had a glitch in one of the automatic scripts that we use to evaluate the solutions and had to reevaluate the solutions last night. After spending the whole night (and unlimited cups of coffee) evaluating and reviewing the different solutions, we have the final list of winning solutions. Thank...

Submit A Solution 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 ...

Submit A Solution 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 will be to create a matrix result...

This challenge is moved to http://beyondrelational.com/modules/19/tcb/297/tsqlbeginnerschallenge1findthesecondhighestsalaryforeachdepartment.aspx?tab=info