USP_DATALIST_ADDONSBYMEMBERSHIPPROGRAAM

                CREATE procedure dbo.USP_DATALIST_ADDONSBYMEMBERSHIPPROGRAAM
                    (
                        @MEMBERSHIPPROGRAMID uniqueidentifier
                    )
               as
                    set nocount on;

                    select 'false' APPLY,
                           MEMBERSHIPPROGRAMADDON.ADDONID,
                           MEMBERSHIPPROGRAMADDON.PRICE,
                           case when MULTIPLEALLOWED = 0 then 1
                                else 0 end
                                as NUMBEROFADDONS,
                           MEMBERSHIPPROGRAMADDON.MULTIPLEALLOWED,
                           MEMBERSHIPPROGRAMADDON.BASECURRENCYID,
                           ADDON.ADDONTYPECODE
                    from dbo.MEMBERSHIPPROGRAMADDON inner join dbo.ADDON on MEMBERSHIPPROGRAMADDON.ADDONID = ADDON.ID
                    where MEMBERSHIPPROGRAMID = @MEMBERSHIPPROGRAMID;