USP_SIMPLEDATALIST_REGISTRANTGUESTSUGGESTION

                CREATE procedure dbo.USP_SIMPLEDATALIST_REGISTRANTGUESTSUGGESTION
                (
                    @CONSTITUENTID uniqueidentifier
                )
                as
                    set nocount on;

                    declare @UNKNOWNGUESTWELLKNOWNGUID uniqueidentifier;
                    set @UNKNOWNGUESTWELLKNOWNGUID = 'C776DAB5-65B2-4258-ADAE-AE396D28E251'; --Well-known GUID for unknown guest


                    select top 100
                        [VALUE],
                        [LABEL]
                    from
                        (
                            select
                                @UNKNOWNGUESTWELLKNOWNGUID [VALUE],
                                dbo.UFN_CONSTITUENT_GETREGISTRANTGUESTSUGGESTIONNAME(@UNKNOWNGUESTWELLKNOWNGUID) [LABEL],
                                null [KEYNAME]

                            union all

                            select distinct top 100
                                CONSTITUENT.ID [VALUE],
                                NF.NAME [LABEL],
                                CONSTITUENT.KEYNAME
                            from 
                                dbo.RELATIONSHIP
                                inner join dbo.CONSTITUENT on RELATIONSHIP.RECIPROCALCONSTITUENTID = CONSTITUENT.ID and CONSTITUENT.ISINACTIVE = 0
                                outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(CONSTITUENT.ID) NF
                            where 
                                RELATIONSHIP.RELATIONSHIPCONSTITUENTID = @CONSTITUENTID
                                and CONSTITUENT.ISORGANIZATION = 0
                                and ISGROUP = 0
                                and not exists (select 1 from dbo.DECEASEDCONSTITUENT where ID = CONSTITUENT.ID)

                            union all

                            select top 100
                                CONSTITUENT.ID [VALUE],
                                NF.NAME [LABEL],
                                CONSTITUENT.KEYNAME
                            from
                                dbo.CONSTITUENT
                                outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(CONSTITUENT.ID) NF
                            where
                                CONSTITUENT.ID = @CONSTITUENTID

                            union all

                            select top 100
                                BATCHREVENUECONSTITUENT.ID [VALUE],
                                dbo.UFN_REVENUEBATCHCONSTITUENT_BUILDNAME(BATCHREVENUECONSTITUENT.ID) [LABEL],
                                BATCHREVENUECONSTITUENT.KEYNAME
                            from
                                dbo.BATCHREVENUECONSTITUENT
                            where
                                BATCHREVENUECONSTITUENT.ID = @CONSTITUENTID
                        ) [SUGGESTIONUNION]
                    order by
                        [SUGGESTIONUNION].[KEYNAME], 2;