UFN_MARRIAGEOPTION_GETRULES

CREATE function dbo.UFN_MARRIAGEOPTION_GETRULES()
returns @RESULT table
(
  UPDATECONTACTINFO bit,
  UPDATENAMEFORMATS bit,
  UPDATEHOUSEHOLDRECOGNITION bit,
  RULESSET bit,
  UPDATEINDIVIDUALRELATIONSHIPS bit
)
as
begin
  insert into @RESULT 
  select top 1
    UPDATECONTACTINFO,
    UPDATENAMEFORMATS,
    UPDATEHOUSEHOLDRECOGNITION,
    case
      when UPDATECONTACTINFO = 1 or UPDATENAMEFORMATS = 1 or UPDATEHOUSEHOLDRECOGNITION = 1 or UPDATEINDIVIDUALRELATIONSHIPS =1 then 1
      else 0
    end as RULESSET,
    UPDATEINDIVIDUALRELATIONSHIPS
  from
    dbo.MARRIAGEOPTION
  order by
    DATEADDED

  if @@ROWCOUNT = 0
  insert into @RESULT
  (
    UPDATECONTACTINFO,
    UPDATENAMEFORMATS,
    UPDATEHOUSEHOLDRECOGNITION,
    RULESSET,
    UPDATEINDIVIDUALRELATIONSHIPS
  )
  values
  (
    0,
    0,
    0,
    0,
    0
  )

  return;
end