USP_MKTFINDERFILE_ADD_LOAD

CREATE procedure dbo.[USP_MKTFINDERFILE_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;

  if @RSCount <= 1
    select top 1 
      [ID] [RECORDSOURCEID],
      1 [RECORDSOURCEHIDDEN]
    from dbo.[MKTRECORDSOURCE] where dbo.[UFN_MKTRECORDSOURCE_VALIDFORPRODUCT]([MKTRECORDSOURCE].[ID]) = 1;
  else
    select top 1 
      [ID] [RECORDSOURCEID],
      0 [RECORDSOURCEHIDDEN]
    from dbo.[MKTRECORDSOURCE] where dbo.[UFN_MKTRECORDSOURCE_VALIDFORPRODUCT]([MKTRECORDSOURCE].[ID]) = 1;

  return 0;