USP_MKTCONSTITUENTFILEIMPORT_ADD_LOAD

CREATE procedure dbo.[USP_MKTCONSTITUENTFILEIMPORT_ADD_LOAD]
(
  @CHANGEAGENTID uniqueidentifier = null
)
as
  set nocount on;

  /* Populate the record source if there is only one... */
  declare @RSCount integer;
  select @RSCount = count(1) from dbo.[MKTRECORDSOURCE] where dbo.[UFN_MKTRECORDSOURCE_VALIDFORPRODUCT]([MKTRECORDSOURCE].[ID]) = 1;

  select top 1
    [MKTRECORDSOURCE].[ID] as [RECORDSOURCEID],
    case when @RSCOUNT <= 1 then 1 else 0 end [RECORDSOURCEHIDDEN],
    [QUERYVIEWCATALOG].[RECORDTYPEID] as [CONSTITUENTRECORDTYPEID]
  from dbo.[MKTRECORDSOURCE] 
  left join dbo.[QUERYVIEWCATALOG] on [QUERYVIEWCATALOG].[ID] = [MKTRECORDSOURCE].[ID]
  where dbo.[UFN_MKTRECORDSOURCE_VALIDFORPRODUCT]([MKTRECORDSOURCE].[ID]) = 1;

  return 0;