Select and Insert using One stored procedure in SQL server

Jes Sie

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

3 Replies

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

Nitin Sontakke9y ago
Accepted answer
So far as possible, try not to persist this kind of information. Unless you want to know the numbers in point of time in the past.

And if that is the case, the date time dimension is missing from above details.
Jes Sie9y ago
You are right Nitin. What I did instead, I inserted the information I wanted from the base transaction. As what you've said "Is there a better way?". Thanks for the insight Nitin. Problem solved. ;)
Nitin Sontakke9y ago
So? What's the question? Where are you stuck?