UFN_AMPROIMPORT_CONSTITUENT_BUILDNAME

                CREATE function dbo.UFN_AMPROIMPORT_CONSTITUENT_BUILDNAME(@ID uniqueidentifier)
                returns nvarchar(154)
                as
                begin
                    if @ID is null
                        return '';

                    declare @NAME nvarchar(154);
                    with CONSTITUENTS (NAME) as
                    (
                        select NAME from dbo.CONSTITUENT where ID = @ID
                        union all
                        select 
                            case CONSTITUENT_ISINDIVIDUAL when 0 then
                                CONSTITUENT_UPDATEDKEYNAME
                            else
                                case CONSTITUENT_UPDATEDFIRSTNAME when '' then '' else CONSTITUENT_UPDATEDFIRSTNAME + ' ' end
                                +
                                CONSTITUENT_UPDATEDKEYNAME
                            end
                        from dbo.BATCHAMPROIMPORTCONSTITUENT where ID = @ID
                    )
                    select top 1 @NAME = NAME from CONSTITUENTS;

                    return @NAME;
                end