Idomiai cia tu :) bandej su didesniu kiekiu irasu, manau jei tas penkias 
eilutes suinsertintum kokius 400 kartu (gautusi 2k irasu), tai tavo 
selektas turetu suktis ne trumpiau kaip 1min ir gautum ta pati jei rasytum:
SELECT [ELEMENT], MIN([START]), MAX([END], [VALUE]
FROM [Table1]
GROUP BY [ELEMENT], [VALUE]

o pastarasis jei uztruks 2ms tai bus maksimumas.


ps. Jei netingi pratestuok, as tingiu, bet esu isitikines 99% kad taip bus.

On 2013.09.22 18:44, blah wrote:
> WITH CteTable AS (
>      SELECT [ELEMENT], [START], [END], [VALUE]
>      FROM [Test].[dbo].[Table1] t1
>      WHERE NOT EXISTS (SELECT 1 FROM [Test].[dbo].[Table1] t2
>                          WHERE t1.[ELEMENT] = t2.[ELEMENT] AND
> t1.[VALUE] = t2.[VALUE] AND DATEADD(DAY, 1, t1.[END]) = t2.[START])
>
>      UNION ALL
>
>      SELECT t3.[ELEMENT], t3.[START], c.[END], t3.[VALUE]
>      FROM [Test].[dbo].[Table1] t3
>     INNER JOIN CteTable c
>         ON t3.[ELEMENT] = c.[ELEMENT] AND t3.[VALUE] = c.[VALUE]
>              AND DATEADD(DAY, 1, t3.[END]) = c.[START]
> ),
> CteTable2 as (
> select [ELEMENT], MIN([START]) as [START], [END], MAX([VALUE]) as [VALUE]
> from CteTable
> group by [ELEMENT], [END]
> )
> select [ELEMENT], [START], MAX([END]) as [END], MAX([VALUE]) as [VALUE]
> from CteTable2
> group by [ELEMENT], [START]