USP_DATALIST_MKTCREATIVEATTACHMENT

Displays a list of all attachments for a creative.

Parameters

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

Definition

Copy



CREATE procedure dbo.[USP_DATALIST_MKTCREATIVEATTACHMENT]
(
@CREATIVEID uniqueidentifier
)
as
  set NOCOUNT on;

  select
    [MKTCREATIVEATTACHMENT].[ID],
    [MKTCREATIVEATTACHMENT].[NAME],
    [MKTATTACHMENTTYPECODE].[DESCRIPTION],
    [MKTCREATIVEATTACHMENT].[FILENAME],
    [MKTCREATIVEATTACHMENT].[DESCRIPTION],
    case when len(isnull([MKTCREATIVEATTACHMENT].[FILENAME], '')) > 0 then convert(uniqueidentifier, '55D98C12-507E-4358-A5C8-5A1611B78DB2') else null end as [VIEWDATAFORMID],
    case when len(isnull([MKTCREATIVEATTACHMENT].[FILENAME], '')) > 0 then 'FILE' else null end as [FILEFIELDID]
  from
    dbo.[MKTCREATIVEATTACHMENT]
  inner join
    dbo.[MKTATTACHMENTTYPECODE] on [MKTATTACHMENTTYPECODE].[ID] = [MKTCREATIVEATTACHMENT].[ATTACHMENTTYPECODEID]
  where
    [MKTCREATIVEATTACHMENT].[CREATIVEID] = @CREATIVEID
  order by
    [MKTCREATIVEATTACHMENT].[NAME];

  return 0;