UFN_TRANSLATIONFUNCTION_VSESUBCATEGORY_GETNAME

                create function dbo.UFN_TRANSLATIONFUNCTION_VSESUBCATEGORY_GETNAME
                (
                    @ID uniqueidentifier
                ) 
                returns nvarchar(100) 
                as
                    begin
                        declare @NAME nvarchar(100);
                        select @NAME = NAME from dbo.VSESUBCATEGORY where ID = @ID;
                        return @NAME;
                    end