USP_MKTCOMMUNICATIONNAMESCHEME_GETPARTSAMPLES

CREATE procedure dbo.[USP_MKTCOMMUNICATIONNAMESCHEME_GETPARTSAMPLES]
(
  @APPEALCODE nvarchar(100) = null output,
  --@MAILINGCODE nvarchar(10) = null output,

  @SITENAME nvarchar(250) = null output
)
as
  set nocount on;

  declare @SQL nvarchar(max);

  if dbo.[UFN_INSTALLEDPRODUCTS_PRODUCTIS]('BB9873D7-F1ED-430A-8AB4-F09F47056538') = 1 and exists(select * from INFORMATION_SCHEMA.TABLES where [TABLE_SCHEMA] = 'RE7' and [TABLE_NAME] = 'APPEAL')
    begin
      --For RE7, we don't have "date added" so just use the next best thing...

      set @SQL = 'select top 1 @APPEALCODE = [NAME] from dbo.[RE7_APPEAL] order by [DATECHANGED] desc';
      exec sp_executesql @SQL, N'@APPEALCODE nvarchar(100) output', @APPEALCODE = @APPEALCODE output;
    end
  else
    select top 1
      @APPEALCODE = [NAME]
    from dbo.[APPEAL]
    order by [DATEADDED] desc;

  select
    --Removing marketing effort code for now...

    --@MAILINGCODE = (select top 1 [CODE] from dbo.[MKTSEGMENTATION] where [CODE] <> '' order by [DATEADDED] desc),

    @SITENAME = (select top 1 [NAME] from dbo.[SITE] order by [DATEADDED] desc);

  return 0;