USP_DATALIST_MKTLISTLAYOUTLISTCONSTITUENTFILEIMPORTS

Displays all the segmented house files that use a specific layout.

Parameters

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

Definition

Copy



CREATE procedure dbo.[USP_DATALIST_MKTLISTLAYOUTLISTCONSTITUENTFILEIMPORTS]
(
  @ID uniqueidentifier
)
as
  set nocount on;

  select
    [ID],
    [NAME],
    [STATUS],
    [STATUSCODE],
    [DATEADDED]
  from dbo.[MKTCONSTITUENTFILEIMPORTPROCESS]
  where [LISTLAYOUTID] = @ID
  order by [NAME], [DATECHANGED] desc;

  return 0;