UFN_DESIGNATION_GETLOOKUPID

            CREATE function dbo.UFN_DESIGNATION_GETLOOKUPID(@ID uniqueidentifier) returns nvarchar(512) WITH EXECUTE as CALLER
            as
            begin
                declare @LOOKUPID nvarchar(512)
                select @LOOKUPID = USERID from dbo.DESIGNATION where ID = @ID
                return @LOOKUPID
            end