UFN_ADHOCQUERY_CHANGEDBYUSER

create function dbo.UFN_ADHOCQUERY_CHANGEDBYUSER(@ID uniqueidentifier)
returns uniqueidentifier
with execute as caller
as begin

    declare @APPUSERID uniqueidentifier
    declare @CHANGEAGENTUSERNAME nvarchar(128)

    select @CHANGEAGENTUSERNAME = [CA].USERNAME
    from [dbo].[ADHOCQUERY] A
    inner join [dbo].[CHANGEAGENT] CA on [CA].[ID] = [A].[CHANGEDBYID]
    where [A].[ID] = @ID

    if @CHANGEAGENTUSERNAME is not null and LEN(@CHANGEAGENTUSERNAME) > 0
        select top 1 @APPUSERID = ID
        from [dbo].[APPUSER] where [CUSTOM_AUTHENTICATION_USERID] = @CHANGEAGENTUSERNAME OR USERNAME = @CHANGEAGENTUSERNAME

    return @APPUSERID
end