TR_MKTSEGMENTATIONEXPORTPROCESS2_INSERT

create trigger [TR_MKTSEGMENTATIONEXPORTPROCESS2_INSERT] on dbo.[MKTSEGMENTATIONEXPORTPROCESS2] after insert not for replication
as
  begin
    set nocount on;

    declare @EXPORTFORMATID uniqueidentifier;
    declare @INSERTEDID uniqueidentifier;
    declare @DATEADDED datetime;
    declare @DATECHANGED datetime;
    declare @ADDEDBYID uniqueidentifier;
    declare @CHANGEDBYID uniqueidentifier;

    if exists (select top 1 1 from inserted)
      begin
        set @EXPORTFORMATID = newid();

        select
          @INSERTEDID = [ID],
          @DATEADDED = [DATEADDED],
          @DATECHANGED = [DATECHANGED],
          @ADDEDBYID = [ADDEDBYID],
          @CHANGEDBYID = [CHANGEDBYID]
        from inserted;

        insert into dbo.[BUSINESSPROCESSEXPORTFORMAT] (
          [ID],
          [CURRENCYSYMBOL],
          [CURRENCYGROUPSEPARATOR],
          [CURRENCYDECIMALSEPARATOR],
          [CURRENCYDECIMALDIGITS],
          [DATEFORMAT],
          [FUZZYDATEFORMAT],
          [MONTHDAYFORMAT],
          [HOURMINUTEFORMAT],
          [DATEADDED],
          [DATECHANGED],
          [ADDEDBYID],
          [CHANGEDBYID]
        )
        select top(1)
          @EXPORTFORMATID,
          [BUSINESSPROCESSEXPORTFORMATCURRENCYSYMBOL],
          [BUSINESSPROCESSEXPORTFORMATCURRENCYGROUPSEPARATOR],
          [BUSINESSPROCESSEXPORTFORMATCURRENCYDECIMALSEPARATOR],
          [BUSINESSPROCESSEXPORTFORMATCURRENCYDECIMALDIGITS],
          [BUSINESSPROCESSEXPORTFORMATDATEFORMAT],
          [BUSINESSPROCESSEXPORTFORMATFUZZYDATEFORMAT],
          [BUSINESSPROCESSEXPORTFORMATMONTHDAYFORMAT],
          [BUSINESSPROCESSEXPORTFORMATHOURMINUTEFORMAT],
          @DATEADDED,
          @DATECHANGED,
          @ADDEDBYID,
          @CHANGEDBYID
        from dbo.[INSTALLATIONINFO];

        insert into dbo.[MKTSEGMENTATIONEXPORTPROCESS2EXPORTFORMAT] (
          [ID],
          [PARAMETERSETID],
          [DATEADDED],
          [DATECHANGED],
          [ADDEDBYID],
          [CHANGEDBYID]
        ) values (
          @EXPORTFORMATID,
          @INSERTEDID,
          @DATEADDED,
          @DATECHANGED,
          @ADDEDBYID,
          @CHANGEDBYID
        );
      end
  end