Picking Insert SQL Begin transaction; INSERT INTO ficpdt ( LIN_LIN,LIN_IVA,LIN_MOV,LIN_QN2,LIN_DCR,LIN_TOT,LIN_DAT,LIN_VAL,LIN_PRC,ESTADO,LIN_REQ,LIN_TAL,LIN_ALT,ART_REF,LIN_STK,LIN_CNV,LIN_ENT,LIN_UNI,LIN_CHV,LIN_INT,LIN_DSC,LIN_TDC,LIN_QNT,LIN_FUN,LIN_CST,LIN_TDS,LIN_DMO,LIN_NUM,LIN_DAD,LIN_LOJ,LIN_IMP,LIN_ACM ) VALUES ( 0,(case when (SELECT iva_tax FROM art WITH(nolock) inner join iva WITH(nolock) on art_iva=iva_cod WHERE art_ref='M91425 / 28/05/2025 14:10:06 / ') is null then '0' else (SELECT iva_tax FROM art WITH(nolock) inner join iva WITH(nolock) on art_iva=iva_cod WHERE art_ref='M91425 / 28/05/2025 14:10:06 / ') end),'0',0,'Artigo inexistente!',0,GETDATE(),'',0.0,9,'M91425 / 28/05/2025 14:10:06 /','',0,'M91425 / 28/05/2025 14:10:06 / ','',0,0,0,(select case when (SELECT max(LIN_CHV)+1 as LIN_CHV FROM ficpdt) is null then 1 else (SELECT max(LIN_CHV)+1 as LIN_CHV FROM ficpdt) end),0,0,'',5.6044699E12,0,0,0,GETDATE(),'55522','',12,0,'s' ); commit transaction; : Data truncation