UFN_INTERACTIONSUBCATEGORY_GETNAME

                create function dbo.UFN_INTERACTIONSUBCATEGORY_GETNAME(@ID uniqueidentifier)
                returns nvarchar(100)
                with execute as caller
                as
                begin
                    declare @NAME nvarchar(100)

                    select @NAME = NAME from dbo.INTERACTIONSUBCATEGORY where ID = @ID

                    RETURN @NAME
                end