I want to select the data from the table in Quarterly
i have the following query but it is suming all the
months and giving
in following query i want to show sum of 01 to
03months in row and o4 to 06 in one row....like
that if i give 200101 to 200112...it has to give me 4
quaters....how to do that..
select CONVERT(CHAR(4),period,112), sum(composite)
where CONVERT(CHAR(6),period,112) between '200101' and
group by CONVERT(CHAR(4),period,112)
order by CONVERT(CHAR(4),period,112)
i used to convert to compare the date in this formate
200101 thats it...