USP_DATALIST_MARKINGCOLUMN

CREATE procedure dbo.USP_DATALIST_MARKINGCOLUMN(@CONTEXTID uniqueidentifier)
as
    set nocount on;

    declare @MINSEQUENCE int = (select min(SEQUENCE) from dbo.MARKINGCOLUMN where MARKINGCOLUMNSETID = @CONTEXTID);
    declare @MAXSEQUENCE int = (select max(SEQUENCE) from dbo.MARKINGCOLUMN where MARKINGCOLUMNSETID = @CONTEXTID);

    select 
        MARKINGCOLUMN.ID,
        MARKINGCOLUMNDESCRIPTIONCODE.DESCRIPTION,
        case when MARKINGCOLUMN.SEQUENCE = @MINSEQUENCE then 1 else 0 end as ISMINSEQUENCE,
        case when MARKINGCOLUMN.SEQUENCE = @MAXSEQUENCE then 1 else 0 end as ISMAXSEQUENCE,
        MARKINGCOLUMN.DISPLAYNAME,
        case MARKINGCOLUMN.ALLTERMS when 1 
            then 'All terms'
            else (select dbo.UDA_BUILDLIST(TERMNAMECODE.DESCRIPTION)
                    from dbo.MARKINGCOLUMNTERM
                        inner join dbo.TERMNAMECODE on MARKINGCOLUMNTERM.TERMNAMECODEID = TERMNAMECODE.ID
                    where MARKINGCOLUMNTERM.MARKINGCOLUMNID = MARKINGCOLUMN.ID) 
            end
        as TERMS
    from dbo.MARKINGCOLUMN
        inner join dbo.MARKINGCOLUMNDESCRIPTIONCODE on MARKINGCOLUMN.MARKINGCOLUMNDESCRIPTIONCODEID = MARKINGCOLUMNDESCRIPTIONCODE.ID
    where MARKINGCOLUMN.MARKINGCOLUMNSETID = @CONTEXTID
    order by MARKINGCOLUMN.SEQUENCE ASC