USP_DATAFORMTEMPLATE_VIEW_MEMBERSHIPSADDONSAVAILABLE

CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_MEMBERSHIPSADDONSAVAILABLE
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @ADDONSAVAILABLE bit = null output,
    @ADDITIONALMEMBERSAVAILABLE bit = null output
)
as
    set nocount on;

    set @DATALOADED = 0;
    set @ADDONSAVAILABLE = 0;
    set @ADDITIONALMEMBERSAVAILABLE = 0;

    select 
        @ADDONSAVAILABLE = 1    
    from 
        dbo.MEMBERSHIPPROGRAM MP
    inner join 
        dbo.MEMBERSHIPPROGRAMADDON MPA on MP.ID = MPA.MEMBERSHIPPROGRAMID
    where 
        MP.ID = @ID;


    select
        @ADDITIONALMEMBERSAVAILABLE = 1
    from
        dbo.MEMBERSHIPPROGRAM MP
    inner join
        dbo.MEMBERSHIPPROGRAMADDON MPA on MP.ID = MPA.MEMBERSHIPPROGRAMID
    inner join
        dbo.ADDON A on A.ID = MPA.ADDONID
    where
        MP.ID = @ID and
        A.ADDONTYPECODE = 1

    set @DATALOADED = 1;
    return 0;