TR_CORRESPONDENCEPROCESS_INSERT (Trigger)

        
CREATE trigger TR_CORRESPONDENCEPROCESS_INSERT on dbo.CORRESPONDENCEPROCESS after insert not for replication
as
begin
  set nocount on;

  declare @TEMP table (
    EXPORTFORMATID uniqueidentifier,
    INSERTEDID uniqueidentifier,
    DATEADDED datetime,
    DATECHANGED datetime,
    ADDEDBYID uniqueidentifier,
    CHANGEDBYID uniqueidentifier
  );

  insert into @TEMP (
    EXPORTFORMATID,
    INSERTEDID,
    DATEADDED,
    DATECHANGED,
    ADDEDBYID,
    CHANGEDBYID
  )
  select
    newid(),
    ID,
    DATEADDED,
    DATECHANGED,
    ADDEDBYID,
    CHANGEDBYID
  from inserted;

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

  insert into dbo.CORRESPONDENCEPROCESSEXPORTFORMAT (
    ID,
    PARAMETERSETID,
    DATEADDED,
    DATECHANGED,
    ADDEDBYID,
    CHANGEDBYID
  )
  select
    EXPORTFORMATID,
    INSERTEDID,
    DATEADDED,
    DATECHANGED,
    ADDEDBYID,
    CHANGEDBYID
  from @TEMP;

end