USP_SIMPLEDATALIST_TERM

CREATE procedure dbo.USP_SIMPLEDATALIST_TERM
(
    @SESSIONID uniqueidentifier = null
)
as
    select 
        TERM.ID as VALUE, 
        DESCRIPTION as LABEL
    from dbo.TERM
    inner join dbo.TERMNAMECODE on TERM.TERMNAMECODEID = TERMNAMECODE.ID
    where (dbo.TERM.SESSIONID = @SESSIONID)
    order by TERM.STARTDATE