USP_DATALIST_MKTMARKETINGPLANITEMATTACHMENT

Displays a list of all attachments for a marketing plan item.

Parameters

Parameter	Parameter Type	Mode	Description
@MARKETINGPLANITEMID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



CREATE procedure dbo.[USP_DATALIST_MKTMARKETINGPLANITEMATTACHMENT]
(
  @MARKETINGPLANITEMID uniqueidentifier
)
as
  set nocount on;

  select
    [MKTMARKETINGPLANITEMATTACHMENT].[ID],
    [MKTMARKETINGPLANITEMATTACHMENT].[NAME],
    [MKTATTACHMENTTYPECODE].[DESCRIPTION] as [Type],
    [MKTMARKETINGPLANITEMATTACHMENT].[FILENAME],
    [MKTMARKETINGPLANITEMATTACHMENT].[DESCRIPTION],
    case when len(isnull([MKTMARKETINGPLANITEMATTACHMENT].[FILENAME], '')) > 0 then convert(uniqueidentifier, 'C7EAF83C-8EBE-4A5A-9BFB-5CB3E9098160') else null end as [VIEWDATAFORMID],
    case when len(isnull([MKTMARKETINGPLANITEMATTACHMENT].[FILENAME], '')) > 0 then 'FILE' else null end as [FILEFIELDID]
  from
    dbo.[MKTMARKETINGPLANITEMATTACHMENT]
  inner join
    dbo.[MKTATTACHMENTTYPECODE] on [MKTATTACHMENTTYPECODE].[ID] = [MKTMARKETINGPLANITEMATTACHMENT].[ATTACHMENTTYPECODEID]
  where
    [MKTMARKETINGPLANITEMATTACHMENT].[MARKETINGPLANITEMID] = @MARKETINGPLANITEMID
  order by
    [MKTMARKETINGPLANITEMATTACHMENT].[NAME];

  return 0;