snowal raj

snowal raj

  • NA
  • 21
  • 11.8k

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


Answers (1)