USP_DATALIST_RATINGSIMPORTPROCESS

                CREATE procedure dbo.USP_DATALIST_RATINGSIMPORTPROCESS
                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 = '4AA3EA1C-9586-41C7-A315-E7A4D0E9690C'
                    order by
                        IMPORTPROCESS.NAME;