UFN_DECEASINGOPTION_GETRULES

            create function dbo.UFN_DECEASINGOPTION_GETRULES
            (
            )
            returns @RESULT table
            (
                UPDATECONSTITUENCIES bit,
                UPDATERELATIONSHIPS bit,
                ADDDOCUMENTATION bit,
                UPDATECONSTITUENTINTERACTIONS bit,
                UPDATECONSTITUENTNAMEFORMATS bit,
                ADDTRIBUTE bit,
                UPDATEHOUSEHOLDMEMBERS bit,
                UPDATEHOUSEHOLDINTERACTIONS bit,
                UPDATEHOUSEHOLDNAMEFORMATS bit,
                SHOWGROUPS bit,
                RULESSET bit
            )
            as

            begin
                insert into @RESULT 
                    select top 1
                        UPDATECONSTITUENCIES,
                        UPDATERELATIONSHIPS,
                        ADDDOCUMENTATION,
                        UPDATECONSTITUENTINTERACTIONS,
                        UPDATECONSTITUENTNAMEFORMATS,
                        ADDTRIBUTE,
                        UPDATEHOUSEHOLDMEMBERS,
                        UPDATEHOUSEHOLDINTERACTIONS,
                        UPDATEHOUSEHOLDNAMEFORMATS,
                        SHOWGROUPS,
                        case
                            when UPDATECONSTITUENCIES = 1 or
                                UPDATERELATIONSHIPS = 1 or
                                ADDDOCUMENTATION = 1 or
                                UPDATECONSTITUENTINTERACTIONS = 1 or
                                UPDATECONSTITUENTNAMEFORMATS = 1 or
                                ADDTRIBUTE = 1 or
                                UPDATEHOUSEHOLDMEMBERS = 1 or
                                UPDATEHOUSEHOLDINTERACTIONS = 1 or
                                UPDATEHOUSEHOLDNAMEFORMATS = 1 or
                                SHOWGROUPS = 1 then 1
                            else 0
                        end as RULESSET
                    from
                        dbo.DECEASINGOPTION
                    order by
                        DATEADDED

                if @@ROWCOUNT = 0
                    insert into @RESULT
                    (
                          UPDATECONSTITUENCIES,
                        UPDATERELATIONSHIPS,
                        ADDDOCUMENTATION,
                        UPDATECONSTITUENTINTERACTIONS,
                        UPDATECONSTITUENTNAMEFORMATS,
                        ADDTRIBUTE,
                        UPDATEHOUSEHOLDMEMBERS,
                        UPDATEHOUSEHOLDINTERACTIONS,
                        UPDATEHOUSEHOLDNAMEFORMATS,
                        SHOWGROUPS,
                        RULESSET
                    )
                    values
                    (
                        0,
                        0,
                        0,
                        0,
                        0,
                        0,
                        0,
                        0,
                        0,
                        0,
                        0
                    )

                return;
            end