USP_DATAFORMTEMPLATE_VIEW_MKTCOMMUNICATIONEFFORTASKLADDEROVERRIDES

CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_MKTCOMMUNICATIONEFFORTASKLADDEROVERRIDES
(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @ASKLADDEROVERRIDES xml = null output,
  @ASKLADDEROVERRIDESLOCKED bit = null output,
  @BASECURRENCYID uniqueidentifier = null output
)
as
  set nocount on;

  set @DATALOADED = 0;

  select
    @DATALOADED = 1,
    @ASKLADDEROVERRIDESLOCKED = [MKTCOMMUNICATIONTEMPLATEDEFAULT].[ASKLADDEROVERRIDESLOCKED],
    @BASECURRENCYID = [MKTSEGMENTATION].[BASECURRENCYID]
  from
    dbo.[MKTSEGMENTATION]
    left join dbo.[MKTCOMMUNICATIONTEMPLATE] on [MKTCOMMUNICATIONTEMPLATE].[MKTSEGMENTATIONID] = [MKTSEGMENTATION].[ID]
    left join dbo.[MKTCOMMUNICATIONTEMPLATEDEFAULT] on [MKTCOMMUNICATIONTEMPLATEDEFAULT].[COMMUNICATIONTEMPLATEID] = [MKTCOMMUNICATIONTEMPLATE].[ID]
  where
    [MKTSEGMENTATION].[ID] = @ID;

  if @DATALOADED = 1
    set @ASKLADDEROVERRIDES = dbo.[UFN_MKTCOMUNICATIONEFFORTASKLADDEROVERRIDES_GETITEMLIST_TOITEMLISTXML](@ID);

  return 0;