UFN_CALENDARCATALOG_GETNAME

                create function dbo.UFN_CALENDARCATALOG_GETNAME(@ID uniqueidentifier)
                returns nvarchar(100)
                as
                begin

                    declare @RETURNVALUE nvarchar(100);

                    select @RETURNVALUE = NAME from dbo.CALENDARCATALOG where ID = @ID;

                    return @RETURNVALUE

                end;