TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Jes Sie
741
1.2k
281.9k
Select and Insert using One stored procedure in SQL server
Apr 4 2017 5:47 AM
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
Reply
Answers (
3
)
Windows Application using c# Code
Could not find installable ISAm