TR_ACKNOWLEDGEMENTPROCESS_INSERT

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

                        end;