UFN_PLANNEDGIFT_GETORDEREDRELATIONSHIPS

            CREATE function dbo.UFN_PLANNEDGIFT_GETORDEREDRELATIONSHIPS
            (
                @PLANNEDGIFTID uniqueidentifier
            )
            returns table
            as
            return 
                select 
                    row_number() over (order by NF.NAME ASC) as ROWNUMBER,
                    NF.NAME as RELATIONSHIPNAME,
                    dbo.UFN_RELATIONSHIPTYPECODE_GETDESCRIPTION(RELATIONSHIP.RELATIONSHIPTYPECODEID) as RELATIONSHIPTYPE
                from
                    dbo.PLANNEDGIFTRELATIONSHIP
                inner join dbo.RELATIONSHIP on PLANNEDGIFTRELATIONSHIP.RELATIONSHIPID = RELATIONSHIP.ID
                cross apply dbo.UFN_CONSTITUENT_DISPLAYNAME(RELATIONSHIP.RECIPROCALCONSTITUENTID) NF
                where
                    PLANNEDGIFTRELATIONSHIP.PLANNEDGIFTID = @PLANNEDGIFTID