USP_SIMPLEDATALIST_MEMBERSHIPLEVELTERM

                CREATE procedure dbo.USP_SIMPLEDATALIST_MEMBERSHIPLEVELTERM
                (
                    @MEMBERSHIPLEVELID uniqueidentifier
                )
                as

                    set nocount on;

                    select
                        MEMBERSHIPLEVELTERM.ID as VALUE,
                        case MEMBERSHIPPROGRAM.PROGRAMTYPECODE when 0 then cast(MEMBERSHIPLEVELTERM.TERMTIMELENGTH as nvarchar(5)) + ' ' + MEMBERSHIPLEVELTERM.TERMLENGTH
                                                                when 1 then MEMBERSHIPLEVELTERM.RECURRINGPAYMENTOPTION
                                                                else case when MEMBERSHIPLEVELTERM.LIFETIMEPAYMENTOPTIONCODE = 0 then MEMBERSHIPLEVELTERM.LIFETIMEPAYMENTOPTION 
                                                                            else cast(MEMBERSHIPLEVELTERM.LIFETIMENUMBEROFPAYMENTS as nvarchar(5)) + ' ' + MEMBERSHIPLEVELTERM.LIFETIMEPAYMENTOPTION + ' payments' end end as LABEL
                    from
                        dbo.MEMBERSHIPLEVELTERM
                        inner join dbo.MEMBERSHIPLEVEL on MEMBERSHIPLEVEL.ID = MEMBERSHIPLEVELTERM.LEVELID
                        inner join dbo.MEMBERSHIPPROGRAM on MEMBERSHIPPROGRAM.ID = MEMBERSHIPLEVEL.MEMBERSHIPPROGRAMID
                    where
                        MEMBERSHIPLEVELTERM.LEVELID = @MEMBERSHIPLEVELID and
                        MEMBERSHIPLEVELTERM.ISACTIVE = 1
                    order by
                        case MEMBERSHIPPROGRAM.PROGRAMTYPECODE when 0 then MEMBERSHIPLEVELTERM.TERMLENGTHCODE when 1 then MEMBERSHIPLEVELTERM.RECURRINGPAYMENTOPTIONCODE else MEMBERSHIPLEVELTERM.LIFETIMEPAYMENTOPTIONCODE end,
                        case MEMBERSHIPPROGRAM.PROGRAMTYPECODE when 2 then MEMBERSHIPLEVELTERM.LIFETIMENUMBEROFPAYMENTS else MEMBERSHIPLEVELTERM.TERMTIMELENGTH end;