Query for Calculate Quarter values in DB2

[rathnam_qv]

Hi all,

Now i am doing Validation..

i have month id's like (201201,201202,201203........201212)Jan  to  Dec..

i am trying to calculate Quarter values..but it's not giving Cumulative values..it's giving value for each month...

can any one help me to get that values for each quarter...

Thanks!!!

Smiley

[kaushiknsolanki]

HI,

     Create a quarter in script.

     Something like this.

     Ceil(num(Month(Makedate(right(Field,4),Left(Field,02))))/3) as Quarter.

     Here Field is the column name which has text inthe form of YYYYMM.

     One you get the correct Quarters then use the Quarter field in your chart/Groups to get Values according to Quarter.

Regards,

Kaushik Solanki

[rathnam_qv]

Hi Kaushik,

Thanks for ur replay

But i need to calculate that in Sql Server

so, i need  SQL Query