Process_inv SQL 
Begin transaction; 


DELETE FROM LIN WHERE LIN_DAD='undefined';
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(19.00, '5600962800240', 'SERIE DE NATAL LED C/300L P/EXTERIOR', (select art_med from art where art_ref='5600962800240'), 0, 0, (select art_med * 19.00 from art where art_ref='5600962800240'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 1, 0, 0.000, '', '5600962800240', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('1',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());

UPDATE DAD SET DAD_MXL=1, DAD_ULT=getdate(), ESTADO=9 WHERE DAD_CHV='undefined'
 commit transaction : Error converting data type varchar to float.