SUM PRICE AND QUNATITY

Question

I NEED TO SUM ITEM QUANTITY,ITEM PRICE DATE WISE AND ALSO CUSTOMER NAME WISE IN REPORT,SQL 2005...REPLY SOON PLEASE

ALTER Procedure[dbo].[PrcInvoiceItemPrint]    

(    

--       @iSalesID      int,   

--       @vAccName      varchar,   

         @iAccID        int,      

         @FromDate      DateTime        

--       @ToDate        DateTime  

    

)    

    

 AS          

 SET NOCOUNT ON         

 BEGIN        

    

--select dInvoiceDate from tblSales where dInvoiceDate=@FromDate    

    

    

--select tblSalesItem.iItemID, Max(tblSalesItem.vTea), SUM(tblSalesItem.iNos)    

--FROM   tblSales INNER JOIN    

--tblSalesItem ON tblSales.iSalesID = tblSalesItem.iSalesID    

--where dInvoiceDate=@FromDate    

--group by tblSalesItem.iItemID    

select tblSales.iAccID, tblSales.vAccName,tblSalesItem.iItemID, tblSalesItem.deAmount,tblSalesItem.vTea,tblSalesItem.iNos,tblSales.dInvoiceDate    

FROM   tblSales INNER JOIN    

tblSalesItem ON tblSales.iSalesID = tblSalesItem.iSalesID    

where tblSales.iAccID=@iAccID AND tblSales.dInvoiceDate=Convert(varchar,@FromDate,101)  

--group by tblSalesItem.iItemID    

    

end