I needed help once more.
I have a select the query below from 1 table (CashierSalesDetails)
- select TransactionNumber, sum(c.ConvertedNetPremium + c.ConvertedVAT + c.ConvertedRegistryFee) as AR
- from CashierSalesDetails c
- where c.TransactionNumber = '000000017'
- group by TransactionNumber
Now, I want to the insert the AR and TransactionNumber fields into table tblAccountsReceivables in the TransactionNumber and AccountsReceivable field together with some other fields:
- @TransactionNumber nvarchar(50),
- @CashierID nvarchar(50),
- @AccountsReceivable decimal(18,2),
- @AgentID nvarchar(50))
Thanks in advance