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
snowal raj
NA
21
12.5k
insert
Jun 4 2014 7:02 AM
INSERT INTO TRANS_PAYMENTINVOICE_DET(ENTRYID,ENTRYNO,ENTRYORDERID,INVOICEENTRYID,PAYMODE,PAYDETAILS,PAYAMOUNT) SELECT @ENTRYID,ENTRYNO,ENTRYORDERID,INVOICEENTRYID,PAYMODE,PAYDETAILS,PAYAMOUNT FROM OPENXML(@HDOC, '/ROOT/TRANS_PAYMENTINVOICE_DET',2) WITH (ENTRYID VARCHAR(30),ENTRYNO VARCHAR(15 ),ENTRYORDERID INT,INVOICEENTRYID VARCHAR(30),PAYMODE VARCHAR(30),PAYDETAILS VARCHAR(50),PAYAMOUNT NUMERIC(18,5)) SET @ERROR=@@ERROR;IF @ERROR<>0 SET @ERR=@ERROR
how to use join query in this sp
Reply
Answers (
1
)
sql
Stored Procedure with dynamic where condition