TR_TRIBUTEACKNOWLEDGEMENTPROCESS_INSERT (Trigger)

                
                    CREATE trigger TR_TRIBUTEACKNOWLEDGEMENTPROCESS_INSERT on dbo.TRIBUTEACKNOWLEDGEMENTPROCESS 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.TRIBUTEACKNOWLEDGEMENTPROCESSEXPORTFORMAT
                    (
                        ID,
                        PARAMETERSETID,
                        DATEADDED,
                        DATECHANGED,
                        ADDEDBYID,
                        CHANGEDBYID
                    )
                    select
                        EXPORTFORMATID,
                        INSERTEDID,
                        DATEADDED,
                        DATECHANGED,
                        ADDEDBYID,
                        CHANGEDBYID
                    from
                        @TEMP

                    end;