|
I seem to get the following error on the line with setamount - 978.
Server: Msg 170, Level 15, State 1, Line 13
Line 13: Incorrect syntax near '='.
any ideas?
update InvestmentSummary
Set UnitsOut = -17849.26409
where InvestmentSummaryUID = 140401
Set AmountOut = 978.63
where InvestmentSummaryUID = 141607
Set AmountOut = 40773.07
where InvestmentSummaryUID = 141603
Set AmountOut = 2622.05
where InvestmentSummaryUID = 141608
Set AmountOut = -1775.192389
where InvestmentSummaryUID = 140404
Set AmountOut = -662.557438
where InvestmentSummaryUID = 140403
--select distinct si.investmentuid,isum.investmentsummaryuid,isum.un itsout,isum.amountout
from investmentsummary isum
inner join schemeinvestment si on si.schemeinvestmentuid = isum.schemeinvestmentuid
where investmentsummaryuid in (select distinct tx.istxuid
from transactionsshadow tx
inner join memberinvestment mi on mi.memberinvestmentuid = tx.parentuid
inner join memberbenefit mb on mb.memberbenefituid = mi.memberbenefituid
inner join schememember sm on sm.memberuid = mb.memberuid
inner join employee ee on ee.employeeuid = sm.employeeuid
inner join person p on p.personuid = ee.personuid
where tx.accounttransactionuid in (@accounttransactionuid)
and p.nationalidnumber = @nino
and tx.rectype = 'D'
and mi.investmentuid in (1028614,1028615,1028616,1742376,1787194))
| 
