UFN_GLOBALCHANGE_CURRENTLYRUNBY

        create function dbo.UFN_GLOBALCHANGE_CURRENTLYRUNBY
        (
            @GLOBALCHANGECATALOGID uniqueidentifier,
            @IGNOREID uniqueidentifier
        ) 
        returns nvarchar(255) 
        with execute as caller
        as
        begin
            declare @USERNAME nvarchar(255);
            set @USERNAME = '';

            select 
                @USERNAME = STARTEDBY.USERNAME 
            from
                dbo.GLOBALCHANGESTATUS
            inner join
                dbo.GLOBALCHANGE on GLOBALCHANGE.ID = GLOBALCHANGESTATUS.PARAMETERSETID
            inner join
                dbo.BUSINESSPROCESSSTATUS on BUSINESSPROCESSSTATUS.ID = GLOBALCHANGESTATUS.ID
            inner join 
                dbo.APPUSER as STARTEDBY on STARTEDBY.ID = BUSINESSPROCESSSTATUS.STARTEDBYUSERID 
            where 
                GLOBALCHANGE.GLOBALCHANGECATALOGID = @GLOBALCHANGECATALOGID 
                and BUSINESSPROCESSSTATUS.STATUSCODE = 1 
                and BUSINESSPROCESSSTATUS.ID <> @IGNOREID;

            return @USERNAME
        end