UFN_JOBOCCURRENCE_GETDESCRIPTION

            create function dbo.UFN_JOBOCCURRENCE_GETDESCRIPTION(@ID uniqueidentifier) returns nvarchar(30) with execute as caller
            as
            begin
                declare @DESCRIPTION nvarchar(30)
                select @DESCRIPTION = DESCRIPTION from dbo.JOBOCCURRENCE where ID = @ID
                return @DESCRIPTION
            end