Try it out below query, You can add more conditions as per your requirement

;WITH Sales AS

(

SELECT CostsAllocated ,

CAST(MONTH(BillDate)AS VARCHAR) +'-' +CAST (YEAR(BillDate)AS VARCHAR) AS BillDate

FROM AcFeesHistory WHERE...

Is that working....???

Try out this...

UPDATE [@BINMATRIX] SET U_CurrentWeight =

(SELECT SUM (CAST(T2.Quantity as numeric)) FROM OIBT T2,[@BINMATRIX] T3 WHERE CAST(T2.Quantity as numeric) > 0 AND

T2.U_Bin = T3.Code AND T2.U_Bin = OIBT.U_Bin)

,Code...

if possible send me some data.. which cause you problem...

(data with expected output)

and also the "OITM" structure for this...

I think there isn't required to user While loop, you just need to remove the [@BINMATRIX] in update query from "FROM"

IF (SELECT (T2.U_Bin) FROM OIBT T2, [@BINMATRIX] T3...

1) There was an older version of SQL Native Access Client (SNAC) on the machine

There was a bug in an earlier (early Pre-RTM) build of SNAC that prevented it from...