TR_MKTSEGMENTATIONEXPORTPROCESS_INSERT (Trigger)

        
CREATE trigger [TR_MKTSEGMENTATIONEXPORTPROCESS_INSERT] on dbo.[MKTSEGMENTATIONEXPORTPROCESS] 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.[MKTSEGMENTATIONEXPORTPROCESSEXPORTFORMAT] (
        [ID],
        [PARAMETERSETID],
        [DATEADDED],
        [DATECHANGED],
        [ADDEDBYID],
        [CHANGEDBYID]
      ) values (
        @EXPORTFORMATID,
        @INSERTEDID,
        @DATEADDED,
        @DATECHANGED,
        @ADDEDBYID,
        @CHANGEDBYID
      );
    end
end