SQL Server 2008
My Table:
InstructionID
CompanyCode
ProductType (F/I/P/C/…)
Amount
Output :
I wish to have a query to return output like
CompanyCode, Count of F, Sum of F, Count of I, Sum of I, Count of P, Sum of P , Count of C, Sum of C
Kindly assist me
Thanks