Loading

SUM

Maneesh A N

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.deAmount,TS.dInvoiceDate

Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'FROM'.

GET ME ANSWER SOON?PLS

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Maneesh A N13y ago
ERROR:
           Msg 8117, Level 16, State 1, Line 1
         Operand data type varchar is invalid for sum operator.


0
Kunal Vaishya13y ago
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.deAmount,TS.dInvoiceDate
0