TR_EXPORTPROCESS_INSERT

CREATE trigger TR_EXPORTPROCESS_INSERT on dbo.EXPORTPROCESS 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,
    CSVLINEBREAKCODE
)
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,
    INSTALLATIONINFO.CSVLINEBREAKCODE
from 
    @TEMP as TEMPINSERTED
cross join 
    (select top(1) 
        BUSINESSPROCESSEXPORTFORMATCURRENCYSYMBOL,
        BUSINESSPROCESSEXPORTFORMATCURRENCYGROUPSEPARATOR,
        BUSINESSPROCESSEXPORTFORMATCURRENCYDECIMALSEPARATOR,
        BUSINESSPROCESSEXPORTFORMATCURRENCYDECIMALDIGITS,
        BUSINESSPROCESSEXPORTFORMATDATEFORMAT,
        BUSINESSPROCESSEXPORTFORMATFUZZYDATEFORMAT,
        BUSINESSPROCESSEXPORTFORMATMONTHDAYFORMAT,
        BUSINESSPROCESSEXPORTFORMATHOURMINUTEFORMAT,
        CSVLINEBREAKCODE
    from dbo.INSTALLATIONINFO) as INSTALLATIONINFO

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

end;