UFN_DECEASINGRULE_GETRULES

            create function dbo.UFN_DECEASINGRULE_GETRULES
            (
            )
            returns @RESULT table
            (
                ADDSOLICITCODE bit,
                SOLICITCODEID uniqueidentifier,
                SETEFTSTATUS bit,
                EFTSTATUSCODE tinyint,
                EFTSTATUS nvarchar(100),
                DISABLEWEATHRATINGS bit,
                DISABLESPOUSERECOGNITIONCREDIT bit,
                SETMARITALSTATUS bit,
                MARITALSTATUSCODEID uniqueidentifier,
                MARKINACTIVE bit
            )
            as

            begin
                insert into @RESULT 
                    select top 1
                        ADDSOLICITCODE,
                        SOLICITCODEID,
                        SETEFTSTATUS,
                        EFTSTATUSCODE,
                        EFTSTATUS,
                        DISABLEWEATHRATINGS,
                        DISABLESPOUSERECOGNITIONCREDIT,
                        SETMARITALSTATUS,
                        MARITALSTATUSCODEID,
                        MARKINACTIVE
                    from
                        dbo.DECEASINGRULE
                    order by
                        DATEADDED

                if @@ROWCOUNT = 0
                    insert into @RESULT
                    (
                        ADDSOLICITCODE,
                        SOLICITCODEID,
                        SETEFTSTATUS,
                        EFTSTATUSCODE,
                        EFTSTATUS,
                        DISABLEWEATHRATINGS,
                        DISABLESPOUSERECOGNITIONCREDIT,
                        SETMARITALSTATUS,
                        MARITALSTATUSCODEID,
                        MARKINACTIVE
                    )
                    values
                    (
                        0,
                        null,
                        0,
                        0,
                        'Pending',
                        0,
                        0,
                        0,
                        null,
                        0
                    )

                return;
            end