Hello naveensg, The sample you gave has the count value for L3AAB8Y - 350M
, as 1, 2, 4 and 4. Should it not be 1, 2, 3 and 4? If you need it just as
Date Combine Month CountOfField
6-Aug-13 L3AAB8Y - 350M Aug-13 4
If thats the case, have you considered using GROUP BY?