This is probably the wrong group for this question but here goes anyway. I
have the following SQL 2005 query:
SELECT DATENAME(month,DateEvent), COUNT(MatterNo)
FROM tblMatx
WHERE WorkType = 'MPS2' AND AgendaCode = 'COMPOSS' AND FutureActual = 'R'
AND DateEvent BETWEEN '01/04/2010' AND '30/06/2010'
GROUP BY DATENAME(Month, DateEvent), MONTH(DateEvent)
ORDER BY Month(DateEvent)
Which returns the following results:
May 8
June 1
I need to to return April and 0 as well. This will apply to other months
in other quarters of the year. Is there a way in T-SQL to force it to
return ALL the months in a quarter?
TIA.
--
ats@work
When an old lady got hit by a truck
I saw the wicked gleam in your eyes
Adam and The Ants - Whip In My Valise
|