USP_DATALIST_RE7INTEGRATIONGIVINGSUMMARYIMPORTPROCESS

                CREATE procedure dbo.USP_DATALIST_RE7INTEGRATIONGIVINGSUMMARYIMPORTPROCESS
                with execute as caller
                as
                    set nocount on;

                    select 
                        IMPORTPROCESS.ID,
                        IMPORTPROCESS.NAME,
                        IMPORTPROCESS.DESCRIPTION,
                        IMPORTPROCESS.FILENAME,
                        IMPORTPROCESS.DATEADDED,
                        CHANGEAGENT.USERNAME
                    from 
                        dbo.IMPORTPROCESS
                        left join dbo.CHANGEAGENT on IMPORTPROCESS.ADDEDBYID = CHANGEAGENT.ID
                    where
                        BATCHTEMPLATEID = '62BA13D6-22A8-4CA4-85CA-5BD3F1CA0A2D'
                    order by
                        IMPORTPROCESS.NAME;