This works fine now. Thank you very much for the help.

I greatly appreciate this. this will solve my problem.

Here is the code:

SELECTRIGHT(CONVERT(VARCHAR, CCD.startDateTime , 105), 7) AS startmonth,

SUM( CASE WHEN CCD.contactDisposition = 1 THEN 1 ELSE 0 END ) AS Abandoned,

SUM( CASE WHEN CCD.contactDisposition = 2...

This works as long as you are with in one year.

If it is more than one year then the data will output as:

Jan-2011,

Jan 2012,

Feb-2011.

Feb-2012,

In this case I want the data...

I will try this way and see.

If I try order by month( startdatetime) then it sorts the data by month.

The problem here is when the data spans to multiple years then it will sort as follows:

Jan...

If I use like above suggestion then I will not get the sum which is grouped by the month

Thank you all very much for instant response. It works fine