UFN_MKTSEGMENTATION_GETREQUIREDFIELDSSET

CREATE function dbo.UFN_MKTSEGMENTATION_GETREQUIREDFIELDSSET
(
  @MAILINGID uniqueidentifier
)
returns bit
as begin
  declare @RET as bit;
  declare @RECORDSOURCEID uniqueidentifier;

  declare RECORDSOURCECURSOR cursor local fast_forward for
    select
      [QUERYVIEWCATALOGID]
    from
      dbo.UFN_MKTSEGMENTATION_GETDISTINCTRECORDSOURCES(@MAILINGID)

  set @RET=1;

  open RECORDSOURCECURSOR;
  fetch next from RECORDSOURCECURSOR into @RECORDSOURCEID;
  while (@@FETCH_STATUS = 0)
  begin
    if dbo.[UFN_MKTRECORDSOURCE_GETREQUIREDFIELDSSET](@RECORDSOURCEID,0)=0
      set @RET=0;
    fetch next from RECORDSOURCECURSOR into @RECORDSOURCEID;
  end;
  close RECORDSOURCECURSOR;
  deallocate RECORDSOURCECURSOR;

  return @RET;
end