USP_SIMPLEDATALIST_MARKINGCOLUMN

            CREATE procedure dbo.USP_SIMPLEDATALIST_MARKINGCOLUMN as
                SELECT MC.ID AS VALUE, (MCS.NAME + ' - ' + MC.DISPLAYNAME) AS LABEL
                FROM MARKINGCOLUMN MC
                INNER JOIN MARKINGCOLUMNSET MCS ON MC.MARKINGCOLUMNSETID = MCS.ID
                ORDER BY MCS.NAME,MC.SEQUENCE