USP_DATAFORMTEMPLATE_VIEW_MEMBERSHIPWORCENTER

CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_MEMBERSHIPWORCENTER
(
  @DATALOADED bit = 0 output,
    @DEFAULTMEMPROCESSEXISTS bit = null output,
  @DEFAULTMEMPROCESSID uniqueidentifier = null output
)
as
    set nocount on;

    -- be sure to set this, in case the select returns no rows
    set @DATALOADED = 1;
  set @DEFAULTMEMPROCESSEXISTS = 0;

  if exists (select 1 from dbo.BUSINESSPROCESSSCHEDULE BPS
      inner join dbo.SCHEDULE S on BPS.SCHEDULEID = S.ID
      inner join dbo.GLOBALCHANGE G on G.ID = BPS.BUSINESSPROCESSPARAMETERSETID
    where 
      S.ID = 'D31014A5-7F9B-4440-9FF3-B15731CD8FF7')
  begin
    set @DATALOADED = 1
    set @DEFAULTMEMPROCESSEXISTS = 1

    select 
      @DEFAULTMEMPROCESSID = G.ID
    from 
      dbo.BUSINESSPROCESSSCHEDULE BPS
      inner join 
      dbo.SCHEDULE S on BPS.SCHEDULEID = S.ID
      inner join 
      dbo.GLOBALCHANGE G on G.ID = BPS.BUSINESSPROCESSPARAMETERSETID
    where 
        S.ID = 'D31014A5-7F9B-4440-9FF3-B15731CD8FF7'
  end


    return 0;