USP_DATAFORMTEMPLATE_VIEW_DIRECTMARKETINGEFFORTBATCHSEGMENT

create procedure dbo.[USP_DATAFORMTEMPLATE_VIEW_DIRECTMARKETINGEFFORTBATCHSEGMENT]
(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @SEGMENTTYPECODE tinyint = null output
)
as
  set nocount on;

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

  if exists(select 1 from dbo.[MKTSEGMENT] where [ID] = @ID)
    --Grab the data for the segment if it already exists.
    select
      @DATALOADED = 1,
      @SEGMENTTYPECODE = [MKTSEGMENT].[SEGMENTTYPECODE]
    from dbo.[MKTSEGMENT]
    where [MKTSEGMENT].[ID] = @ID;
  else
    --If the segment does not exist yet, then grab the data from the batch table.
    select
      @DATALOADED = 1,
      @SEGMENTTYPECODE = [BATCHDIRECTMARKETINGEFFORTSEGMENT].[SEGMENTTYPECODE]
    from dbo.[BATCHDIRECTMARKETINGEFFORTSEGMENT]
    where
      [BATCHDIRECTMARKETINGEFFORTSEGMENT].[ID] = @ID;

  return 0;