adding month as columns in SQL query
I am new in SQL query world. I would like to ask a question
I have a Query like this
SELECT CAST(T2.AliasNAme AS NVARCHAR(100)) as 'Company', T0.BPLName as 'Branch', T1.SLPName as 'Sales', T3.CardCode, T3.CardName, COUNT(T3.CardCode) as 'Total' FROM OINV T0 INNER JOIN OSLP T1 ON T0.SLPCode = T1.SLPCode INNER JOIN OCRD T3 ON T0.CardCode = T3.CardCode , OADM T2 WHERE CANCELED = 'N' GROUP BY T0.BPLName, T3.CardName, T3.CardCode, T1.SLPName, CAST(T2.AliasNAme AS NVARCHAR(100)), T3.CardCode ORDER BY T1.SLPName
It will give me data about total invoice per customer made by sales person.
what I want to do is I want to add month column (jan, feb, mar,…. dec) and the month column will show total invoice per customer made by sales person for the selected months (example : sales A, Cust AA, in Jan got 5 invoice, Feb 1 invoice, Mar 10 ~)
can anyone help me how to get that result or better explain me the queries?
thank you very much your help will be greatly appreciated.