USP_SIMPLEDATALIST_TIERCODE

            CREATE procedure dbo.USP_SIMPLEDATALIST_TIERCODE(

            @MEMBERSHIPPROGRAMID uniqueidentifier

            )

            as
                set nocount on;
                select distinct
                    TIERCODE.ID as VALUE,
                    TIERCODE.DESCRIPTION as LABEL
                    from
                    dbo.MEMBERSHIPLEVEL
                    inner join dbo.TIERCODE on MEMBERSHIPLEVEL.TIERCODEID = TIERCODE.id
                    where        
                    @MEMBERSHIPPROGRAMID = MEMBERSHIPLEVEL.MEMBERSHIPPROGRAMID