Success

struct
CACHED	false
EXECUTIONTIME	4
GENERATEDKEY	274542208
IDENTITYCOL	274542208
RECORDCOUNT	1
SQL	insert into tbl_IMPORT_TEXT ( ownerId, ownerType, eai_batchId, eai_lineNumber, line_of_text ) select ownerId, ownerType, eai_batchId, eai_lineNumber, line_of_text from ( values ( 0, 'MFR', 0, 0, 'some text' ) ) as x ( ownerId, ownerType, eai_batchId, eai_lineNumber, line_of_text )

Failure

struct
CACHED	false
EXECUTIONTIME	6
RECORDCOUNT	1
SQL	insert into tbl_TPM_Claims ( ownerId, ownerType, deductionRef, claimAmount, claimStatus, processorUserId, readyToAudit , createDate, createUserId, updateDate, updateUserId , claimInvoice , claimRef , claimDate , claimPeriodStart , claimPeriodEnd , partnerId , partnerType , claimType , claimDescription , currencyCode , currencyConversionRate ) select ownerId, ownerType, '20210525155-R' deductionRef, claimAmount * -1 as claimAmount, claimStatus, 4253137 as processorUserId, 'Y' readyToAudit, getDate() createDate, 4253137 as createUserId, getDate() as updateDate, 4253137 as updatUserId , claimInvoice , claimRef , claimDate , claimPeriodStart , claimPeriodEnd , partnerId , partnerType , claimType , claimDescription , currencyCode , currencyConversionRate from tbl_TPM_Claims with (nolock) where ownerId = 276 and ownerType = 'MFR' and claimId = 330388