USP_SIMPLEDATALIST_PATTERNBLOCK_BYCOURSE_BYSESSION

CREATE procedure dbo.USP_SIMPLEDATALIST_PATTERNBLOCK_BYCOURSE_BYSESSION 
(
    @COURSEID uniqueidentifier,
    @SESSIONID uniqueidentifier
)
as
    declare @SESSION_STARTDATE date
    declare @SESSION_ENDDATE date

    select
        @SESSION_STARTDATE = min(STARTDATE),
        @SESSION_ENDDATE = max(ENDDATE)
    from dbo.TERM
    where TERM.SESSIONID = @SESSIONID

    select
        dbo.PATTERNBLOCK.[ID] as VALUE, 
        dbo.PATTERNBLOCK.[NAME] as LABEL
    from dbo.PATTERNBLOCK
        inner join dbo.V_COURSERESTRICTION COURSERESTRICTION on PATTERNBLOCK.PATTERNID = COURSERESTRICTION.PATTERNID
    where COURSERESTRICTION.COURSEID = @COURSEID
        and COURSERESTRICTION.STARTDATE = @SESSION_STARTDATE
        and COURSERESTRICTION.ENDDATE = @SESSION_ENDDATE