SUM

Question

SELECT SUM(SI.vItemName)SUM(SI.iNos)SUM(SI.deAmount)SUM(TS.dInvoiceDate) FROM tblSales TS INNER JOIN tblSalesItem SI ON TS.iSalesID=SI.iSalesID GROUP BY SI.vItemName SI.iNos SI.deAmountTS.dInvoiceDate Msg 156 Level 15 State 1 Line 2 Incorrect syntax near the keyword 'FROM'. GET ME ANSWER SOON?PLS

Maneesh A N · Answer

ERROR: Msg 8117 Level 16 State 1 Line 1 Operand data type varchar is invalid for sum operator.

Kunal Vaishya · Answer

Hi try this  SELECT SUM(SI.vItemName) as vItemName SUM(SI.iNos) As iNos SUM(SI.deAmount) As deAmount SUM(TS.dInvoiceDate) As dInvoiceDate FROM tblSales As TS INNER JOIN tblSalesItem As SI ON TS.iSalesID=SI.iSalesID GROUP BY SI.vItemName SI.iNos SI.deAmountTS.dInvoiceDate