Hi,

This code may help you

create table Customer_Bill_Table

(

[CustmoerNO] VARCHAR(3)

, [productname] VARCHAR(15)

, [billeddate ] VARCHAR(15)

)

INSERT INTO Customer_Bill_Table([CustmoerNO],[productname],[billeddate ])

SELECT '50','Milk','10/4/2013' UNION ALL

SELECT '50','Milk','11/4/2013'UNION ALL

SELECT '50','Curd','15/4/2013'UNION ALL

SELECT '50','Curd','15/4/2013'UNION ALL

SELECT '50','Biscuit','14/4/2013'UNION ALL

SELECT '50','Biscuit','16/4/2013'UNION ALL

SELECT '40','Biscuit','1/4/2013'UNION ALL

SELECT '40','Milk','10/4/2013'UNION ALL

SELECT '40','Milk','11/4/2013'UNION ALL

SELECT '40','Curd','15/4/2013'UNION ALL

SELECT '40','Biscuit','14/4/2013'UNION ALL

SELECT '40','Milk','6/4/2013'UNION ALL

SELECT '40','Curd','21/4/2013'

select * from Customer_Bill_Table

select [CustmoerNO],[productname],count([billeddate]) As Nobillspermonth

from Customer_Bill_Table group by [CustmoerNO],[productname]