UFN_NAMINGOPPORTUNITYRECOGNITION_BUILDNAME

                CREATE function dbo.UFN_NAMINGOPPORTUNITYRECOGNITION_BUILDNAME
                (
                    @ID uniqueidentifier
                )        
                returns nvarchar(200)
                as
                begin

                    declare @R nvarchar(250);
                    declare @NAMINGOPPORTUNITY nvarchar(100);
                    declare @RECOGNITIONNAME nvarchar(100);

                    set @R = '';

                    select
                        @NAMINGOPPORTUNITY = dbo.UFN_NAMINGOPPORTUNITY_BUILDNAME(NAMINGOPPORTUNITYID),
                        @RECOGNITIONNAME = NAMINGOPPORTUNITYRECOGNITION.CONSTITUENTNAME
                    from dbo.NAMINGOPPORTUNITYRECOGNITION
                    where NAMINGOPPORTUNITYRECOGNITION.ID = @ID;

                    set @R = @NAMINGOPPORTUNITY;
                    if len(@RECOGNITIONNAME) > 0
                    begin
                        if len(@R) > 0
                            set @R = @R + ' - ';
                        set @R = @R + @RECOGNITIONNAME;
                    end

                    return @R;
                end