Please see [this post][1] which explains how to format code listing [1]: http://beyondrelational.com/modules/23/pages/362/posts/13661/tips-and-tricks-for-formatting-code-blocks-sample-code-listing.aspx

The challenge is to find the minimal set of intervals without creating gaps. There is a table with groups of redundantly overlapping date intervals where each group has no gaps. Given this table, your job is to find the minimum set of date intervals witho

Close to 30 TSQL enhancements added in SQL Server 2012 is listed [here][1] with some examples. Here are a few: 1. [LEAD()][2] 2. [LAST_VALUE()][3] 3. [FIRST_VALUE()][4] 4. [OFFSET and FETCH NEXT][5] 5. [ROWS BETWEEN PRECEDING X AND CURRENT][6

This challenge invites you to identify the largest sequence of alphabets from a string.

A website wants to display most relevant ads on each of its web pages based on the keywords associated with each page. Your job is to write a TSQL query that returns the advertisements most relevant to each web page given in the source table.

@Parth, The first row in the Tally Table that is used for evaluation is 0. It is recommended that you use the exact script. You can submit a solution even after evaluation and it will be processed in subsequent evaluation cycles.

@logeswari, The result should be `A`

Guna, Look at this example `ABCDAFGKFLMNO` contains two sequences `ABCD` and `LMNO` and both of them are 4 characters long. In such a case you should pick the value that starts earlier: in this example `ABCD`

This is the test configuration used. I will get the other page updated soon. - OS: Windows 7 Ultimate - Processor: Intel(R) Core(TM) i5 CPU M460 @ 2.53 GHz - Memory: 8 GB - System Type: 64 Bit Operating System - SQL Server Version: SQL Ser

All the solutions of this challenge were tested with Denali CTP3. The comparison page seems to be wrong. I will get this fixed.