insert

Hi try this script.


DECLARE @HDOC int  
 exec sp_xml_preparedocument @HDOC OUTPUT,@ENTRYID
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)) xmlENtry

EXEC sp_xml_removedocument @hDoc

SET @ERROR = @@ERROR;
IF @ERROR <> 0
   SET @ERR = @ERROR