USP_MKTSEGMENTWHITEMAIL_LOAD

CREATE procedure dbo.[USP_MKTSEGMENTWHITEMAIL_LOAD]
(
  @ID uniqueidentifier,
  @CURRENTAPPUSERID uniqueidentifier,
  @SECURITYFEATUREID uniqueidentifier = null
)
as
  set nocount on;

  declare @DATALOADED bit;
  declare @QUERYVIEWCATALOGID uniqueidentifier;
  declare @NAME nvarchar(100);
  declare @DESCRIPTION nvarchar(255);
  declare @SITEID uniqueidentifier;
  declare @SITEREQUIRED bit;
  declare @SEGMENTCATEGORYCODEID uniqueidentifier;
  declare @CODEVALUEID uniqueidentifier;
  declare @CODE nvarchar(10);
  declare @GROUPS xml;
  declare @TSLONG bigint;

  begin try
    exec dbo.[USP_DATAFORMTEMPLATE_EDITLOAD_MKTSEGMENT_2]
      @ID = @ID,
      @CURRENTAPPUSERID = @CURRENTAPPUSERID,
      @DATALOADED = @DATALOADED output,
      @NAME = @NAME output,
      @DESCRIPTION = @DESCRIPTION output,
      @SEGMENTCATEGORYCODEID = @SEGMENTCATEGORYCODEID output,
      @CODE = @CODE output,
      @QUERYVIEWCATALOGID = @QUERYVIEWCATALOGID output,
      @SELECTIONS = null,
      @GROUPS = @GROUPS output,
      @SMARTQUERIESEXIST = null,
      @ISINUSE = null,
      @DATECHANGED = null,
      @ALLOWCODEUPDATE = null,
      @CODEVALUEID = @CODEVALUEID output,
      @TSLONG = @TSLONG output,
      @SITEID = @SITEID output,
      @SITEREQUIRED = @SITEREQUIRED output,
      @FORMID = 'DDED9EDA-84DF-498F-9FFF-60840E74A0FE';

    if @DATALOADED = 1
      select
        @QUERYVIEWCATALOGID as [QUERYVIEWCATALOGID],
        @NAME as [NAME],
        @SITEID as [SITEID],
        @SITEREQUIRED as [SITEREQUIRED],
        @DESCRIPTION as [DESCRIPTION],
        @SEGMENTCATEGORYCODEID as [SEGMENTCATEGORYCODEID],
        --[SEGMENTATIONID],

        [STATUSCODE],
        [ACTIVEFROM],
        [ACTIVETO],
        [SOURCECODEID],
        dbo.[UFN_MKTSOURCECODEPART_WHITEMAILSEGMENT_GETITEMLIST2_TOITEMLISTXML](@ID) as [SOURCECODEITEMLIST],
        @CODEVALUEID as [CODEVALUEID],
        @CODE as [CODE],
        dbo.[UFN_MKTSOURCECODEPARTDEFINITIONVALUE_GETAUTOINCREMENTSETTING](@CODEVALUEID) as [AUTOINCREMENTCODE],
        @GROUPS as [GROUPS],
        convert(bit, case when (select isnull(sum([RESPONSES]), 0) from dbo.[MKTSEGMENTWHITEMAILCACHE] where [ID] = @ID) > 0 then 1 else 0 end) as [INUSE],
        @TSLONG as [TSLONG]
      from dbo.[MKTSEGMENTWHITEMAIL]
      where [ID] = @ID;

    set @SITEREQUIRED = dbo.[UFN_SITEREQUIREDFORUSERONFEATURE](@CURRENTAPPUSERID, @SECURITYFEATUREID, 1);
  end try

  begin catch
    exec dbo.[USP_RAISE_ERROR];
    return 1;
  end catch

  return 0;