DECLARE @FieldId AS varchar(50) = 'aaaaaaaa-cb67-e811-a84b-000d3a2a979c';
DECLARE @ContactMapping AS varchar(50) = 'emailaddress1';
DECLARE @MarketingFormFieldType AS varchar(50) = '1';
DECLARE @FieldFormat AS varchar(50) = '3';
DECLARE @DefaultFormLabel AS varchar(50) = 'E-mail';
DECLARE @LeadMapping AS varchar(50) = 'emailaddress1';
DECLARE @Name AS varchar(50) = 'Email';
DECLARE @RenderAs AS varchar(50) = '2';
DECLARE @MarketingProvided AS varchar(50) = 'True';

DECLARE @CreatedOn AS datetime;
DECLARE @CreatedBy AS uniqueidentifier;
DECLARE @ModifiedOn AS datetime;
DECLARE @ModifiedBy AS uniqueidentifier;
DECLARE @OwnerId AS uniqueidentifier;
DECLARE @OwnerIdType AS int;
DECLARE @OwningBusinessUnit AS uniqueidentifier;
DECLARE @StateCode AS int;
DECLARE @StatusCode AS int;

SELECT TOP 1
    @CreatedOn = CreatedOn,
	@CreatedBy = CreatedBy,
    @ModifiedOn = ModifiedOn,
    @ModifiedBy = ModifiedBy,
    @OwnerId = OwnerId,
    @OwnerIdType = OwnerIdType,
    @OwningBusinessUnit = OwningBusinessUnit,
    @StateCode = statecode,
    @StatusCode = statuscode
FROM msdyncrm_marketingformfieldBase;
INSERT INTO msdyncrm_marketingformfieldBase
(
    msdyncrm_marketingformfieldId,
    msdyncrm_contactmapping,
    msdyncrm_marketingformfieldtype,
    msdyncrm_format,
    msdyncrm_defaultformlabel,
    msdyncrm_leadmapping,
    msdyncrm_name,
    msdyncrm_renderas,
    msdyncrm_marketingprovided,
    CreatedOn,
    CreatedBy,
    ModifiedOn,
    ModifiedBy,
    OwnerId,
    OwnerIdType,
    OwningBusinessUnit,
    statecode,
    statuscode
)
VALUES
(
    CAST(@FieldId as uniqueidentifier),
    @ContactMapping,
    CAST(@MarketingFormFieldType as int),
    CAST(@FieldFormat as int),
    @DefaultFormLabel,
    @LeadMapping,
    @Name,
    CAST(@RenderAs as int),
    CAST(@MarketingProvided as bit),
    @CreatedOn,
    @CreatedBy,
    @ModifiedOn,
    @ModifiedBy,
    @OwnerId,
    @OwnerIdType,
    @OwningBusinessUnit,
    @StateCode,
    @StatusCode
)