USP_REPORT_APPEALPROFILE_MAILINGS

CREATE procedure dbo.[USP_REPORT_APPEALPROFILE_MAILINGS]
(
  @APPEALID uniqueidentifier = null,
  @SHOW bit = null
)
as
  set nocount on;

  begin try
    if @SHOW = 1
      begin
        -- NOTE: Be sure to update AppealProfileReportSectionsHaveData.View.xml if you modify

        -- the joins/constraints of the below query.


        select 
          'http://www.blackbaud.com/' + 
            (case when [APPEALMAILING].[ID] is not null then
               'APPEALMAILINGID?APPEALMAILINGID'
             else
               (case when [MKTSEGMENTATION].[MAILINGTYPECODE] = 4 then
                  'PUBLICMEDIAEFFORTID'
                else
                  'MKTSEGMENTATIONID'
                end) + '?MKTSEGMENTATIONID'
             end) + '=' + convert(nvarchar(36), [MKTSEGMENTATION].[ID]) as [MKTSEGMENTATIONID],
          [MKTSEGMENTATION].[NAME],
          [MKTSEGMENTATION].[DESCRIPTION]
        from dbo.[MKTSEGMENTATIONACTIVATE]
        inner join dbo.[MKTSEGMENTATION] on [MKTSEGMENTATION].[ID] = [MKTSEGMENTATIONACTIVATE].[SEGMENTATIONID]
        left join dbo.[APPEALMAILING] on [APPEALMAILING].[ID] = [MKTSEGMENTATION].[ID]
        where [MKTSEGMENTATIONACTIVATE].[APPEALSYSTEMID] = cast(@APPEALID as nvarchar(36))
        and [MKTSEGMENTATIONACTIVATE].[RECORDSOURCEID] = 'DFB4B8C1-5E9A-4C14-ACE3-01C096B53BA0'
        order by [MKTSEGMENTATION].[NAME];
      end
  end try

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

  return 0;