I'm very thank ful to all .

Its great pleasure to know all the valueable suggestions and solutions.

thanks jeff for your valuable advice .

I should change the order by n.date final select as below :

SELECT CONVERT(varchar(20), N.date , 101) AS DATECOL, T.WEIGHTS

FROM AllDatesCTE AS N

...

Here is the another solution ;

;WITH DigitsCTE AS

(

SELECT digit

FROM (VALUES(0), (1), (2), (3), (4), (5), (6), (7), (8), (9)) AS D(digit)

)

, AllDatesCTE...

thanks for all for the valuable different methods . which were really help me to think in different perspectives.

I have gone thorough the all the solutions .

I...

Jeff Moden (7/22/2012)

There's a question in my mind that's still outstanding about all of this. Do you just want to return a result set or...

Thanks to all ,

excellent . Thank you ...!

SSCrazy,

It will work I think . REFERENCE_ID ...

Great Result ...

Thank you very much ..

Wow .. Thanks.,

This big code working Great .. I will do some testing on this ....

Thanks a lot

I think it will not work in all cases .What will happen if I add another...

I am trying with permutation and combinations ... not yet figure out.

Still trying ..

I tried this ...

But getting same rank for all TECH_MODE 5, Some where partition is missing .

I am unable figure out it.

SELECT * , DENSE_RANK() OVER(...

The input data always consistent .

begin_time having incremental date also end_time having incremental date.

I need to group the Consecutive TECH_MODE records by selecting MIN(BEGIN_TIME) , MAX(END_TIME)

-- Output...

The pattern is consistent ..

Always BEGIN_TIME of records is greater then the END_TIME of previous record.