UFN_EVENTLOCATIONROOM_GETNAME

                create function dbo.UFN_EVENTLOCATIONROOM_GETNAME(@ID uniqueidentifier) returns nvarchar(50) 
                as
                begin
                    declare @NAME nvarchar(100)
                    select @NAME = NAME from dbo.EVENTLOCATIONROOM where ID = @ID
                    return @NAME
                end