UFN_SEARCHHISTORYUSER_GETUSERNAME

                create function dbo.UFN_SEARCHHISTORYUSER_GETUSERNAME(@ID uniqueidentifier)
                returns nvarchar(100)
                with execute as caller
                as begin
                    declare @USERNAME nvarchar(100);

                    select
                        @USERNAME = coalesce(C.NAME,A.USERNAME)
                    from 
                        dbo.WPSEARCHHISTORY H
                        inner join dbo.APPUSER A on A.ID=H.APPUSERID
                        left outer join dbo.CONSTITUENT C on C.ID=A.CONSTITUENTID
                    where H.ID = @ID

                    return @USERNAME;
                end