alright,here u go

declare @temp5 table

(id int,

ThruDate datetime,

total)

result of temp5

1 2010-09-30 00:00:00.000 20

1 2009-12-31 00:00:00.000 ...

thanks everybody.

i have 1 more que

my result set should be like this

account fromdate total bench1 bench2

1 09/30/2010...

ok.

what i want is you see the dates in bold is repeating at the end.

so i want 1 section from 09/30/2010 to 12/31/2010

and another 08/31/2008 to 12/31/2010

but in the...

thanks but what if i get data like this,

2010-09-30 00:00:00.0002010-10-31 00:00:00.000

2010-10-31 00:00:00.0002010-11-30 00:00:00.000

2010-11-30 00:00:00.0002010-12-31 00:00:00.000

2008-12-31 00:00:00.0002009-01-31 00:00:00.000

2009-01-31 00:00:00.0002009-02-28 00:00:00.000

2009-02-28 00:00:00.0002009-03-31 00:00:00.000

2009-03-31 00:00:00.0002009-04-30 00:00:00.000

2009-04-30 00:00:00.0002009-05-31 00:00:00.000

2009-05-31 00:00:00.0002009-06-30 00:00:00.000

2009-06-30 00:00:00.0002009-07-01 00:00:00.000

2009-07-01 00:00:00.0002009-07-02...