TR_PLEDGEREMINDERPROCESS_INSERT

create trigger TR_PLEDGEREMINDERPROCESS_INSERT on dbo.[PLEDGEREMINDERPROCESS] 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.[PLEDGEREMINDERPROCESSEXPORTFORMAT]
(
  [ID],
  [PARAMETERSETID],
  [DATEADDED],
  [DATECHANGED],
  [ADDEDBYID],
  [CHANGEDBYID]
)
select
  [EXPORTFORMATID],
  [INSERTEDID],
  [DATEADDED],
  [DATECHANGED],
  [ADDEDBYID],
  [CHANGEDBYID]
from @TEMP;

end;