USP_SIMPLEDATALIST_MEMBERSHIPCARDS

CREATE procedure dbo.USP_SIMPLEDATALIST_MEMBERSHIPCARDS
(
    @MEMBERSHIPID uniqueidentifier
)
as
    select MEMBER.CONSTITUENTID as VALUE
        , mc.NAMEONCARD as LABEL
        , mc.EXPIRATIONDATE as DESCRIPTION
    from dbo.MEMBERSHIPCARD mc
        inner join dbo.MEMBER on MEMBER.ID = mc.MEMBERID
    where MEMBER.MEMBERSHIPID = @MEMBERSHIPID
    and mc.STATUSCODE <> 2