BEGIN TRAN

INSERT INTO [productdb].[dbo].[Avtal_Confirm_EsignedDocument]

(

    [elavtalId],

    [filename],

    [BLOB],

    [BLOBMimeType],

    [signeddoc_id],

    [email],

    [mobile],

    [signdate],

    [senddate],

    [insertdate]

)

SELECT

    5002402 AS [elavtalId],   -- avtalet som esigneringen ska hamna på

    [filename],

    [BLOB],

    [BLOBMimeType],

    [signeddoc_id],

    [email],

    [mobile],

    [signdate],

    [senddate],

    [insertdate]

FROM [productdb].[dbo].[Avtal_Confirm_EsignedDocument]

WHERE [id] = 81;             -- esignering att duplicera

ROLLBACK

--COMMIT

----Hitta ett id att duplicera--

--SELECT *

--FROM [productdb].[dbo].[Avtal_Confirm_EsignedDocument]

--ORDER BY id desc