UFN_MARRIAGERULE_GETRULES

CREATE function dbo.UFN_MARRIAGERULE_GETRULES()
returns @RESULT table
(
  SETMARITALSTATUS bit,
  MARITALSTATUSCODEID uniqueidentifier,
  COPYPHONENUMBER bit,
  COPYEMAILADDRESS bit
)
as
begin
  insert into @RESULT 
  select top 1
    SETMARITALSTATUS,
    MARITALSTATUSCODEID,
    COPYPHONENUMBER,
    COPYEMAILADDRESS
  from
    dbo.MARRIAGERULE
  order by
    DATEADDED

  if @@ROWCOUNT = 0
    insert into @RESULT
    (
      SETMARITALSTATUS,
      MARITALSTATUSCODEID,
      COPYPHONENUMBER,
      COPYEMAILADDRESS
    )
    values
    (
      0,
      null,
      1,
      1
    )

  return;
end