Hi

I have already defined in my query the year strings...

have a look here:

Select

AREA,SRC

,case

when DATE between '1/1/2010' AND getdate() THEN 'YTD 2010'

when DATE between '1/1/2009' AND dateadd(yy,-1,getdate()) THEN 'YTD 2009'

else 'Not Required'end AS PERIOD

,COUNT(distinct ACCOUNT_NO) as AC_Count

from dbo.Dim1

where FILTER_CODE not in ('4','9','unknown')

group by

AREA,SRC

,case

when DATE between '1/1/2010' AND getdate() THEN 'YTD 2010'

when DATE between '1/1/2009' AND dateadd(yy,-1,getdate()) THEN 'YTD 2009'

else 'Not Required'end