简单使用 case 具有窗口功能：

select t.*,
       (case when min(start) over (partition by name) = max(start) over (partition by name) and
                  min(end) over (partition by name) = max(end) over (partition by name) and
                  start = end
             then 'Yes' else 'No'
        end) as flag
from trial t;

这是一把小提琴。
注： end 是一个非常糟糕的列名称，因为它是一个sql关键字。

你可以试试窗口功能 Row_Number() 如下图所示：

Create table MyTable (Name varchar(50),
Trial Char(1),
Start Varchar(20),
[End] Varchar(20))

Insert into MyTable Values
('Julie', 'A', 'Ranch St', 'Ranch St'),
('Julie', 'B', 'Ranch St', 'North Blvd'),
('James', 'A', 'Deer Rd', 'Deer Rd'),
('James', 'B', 'Deer Rd', 'Deer Rd')

;with cte as (Select name
,trial
,start
,[End]
,Row_number() Over(Partition By [Start], [End] order by [Start], [End]) as SrNo
From MyTable
)
Select 
   name, trial, start, [End], 'Yes' as [Expected Output] 
from cte where name in ( Select name from cte where SrNo > 1)
union all
Select 
   name, trial, start, [End], 'No' as [Expected Output] 
from cte where name not in (Select name from cte where SrNo > 1)
order by name

现场演示

检查给定的查询

DECLARE @Counter int  
DECLaRE @CMS_Query varchar(MAX)
DECLARE @total_Row int
DECLARE Cur_1 CURSOR FOR select Name from Trial group by Name

Create Table #MainTrial(
[Name] varchar(MAX),
Trial varchar(MAX),
[Start] varchar(MAX),
[END] varchar(MAX),
[TrialChk] varchar(3)
)
OPEN Cur_1
    DECLARE @Name varchar(MAX)
    FETCH NEXT FROM Cur_1 INTO @Name
        WHILE (@@FETCH_STATUS = 0)
            Begin

                SELECT  a.[Name],Trial,Start,[End],CASE WHEN a.[Start] = a.[END] THEN 'Yes' ELSE 'No'END AS 'TrialChk' into #Trial1 FROM Trial AS a  where Name = @Name

                select @total_Row = count(*) from #Trial1
                select @Counter = COUNT(*) from #Trial1 where TrialChk = 'Yes'

                IF @total_Row != @Counter
                    BEGIN
                        UPDATE #Trial1 SET TrialChk = 'No' where [Name] = @Name
                    END
                insert into #MainTrial select * from #Trial1
                DROP Table #Trial1
                FETCH NEXT FROM Cur_1 INTO @Name
            END
CLOSE Cur_1
DEALLOCATE Cur_1
select * from #MainTrial
drop table #MainTrial

如果你 GROUP BY Name 数一数 Start s和 End s、 就像这个查询一样：

SELECT Name, COUNT(DISTINCT Start) start_counter, COUNT(DISTINCT [End]) end_counter
FROM Trial
GROUP BY Name

你会得到这些结果：

> Name  | start_counter | end_counter
> :---- | ------------: | ----------:
> Emily |             1 |           2
> Frank |             1 |           1
> James |             1 |           1
> Jeff  |             2 |           2
> Julie |             1 |           2

因此，您可以将上述查询连接到表并设置 'Yes' 其中2个计数器都等于1，否则设置 'No' :

SELECT t.*,
  CASE WHEN c.start_counter = 1 AND c.end_counter = 1 THEN 'Yes' ELSE 'No' END Result
FROM Trial t 
INNER JOIN (
  SELECT Name, COUNT(DISTINCT Start) start_counter, COUNT(DISTINCT [End]) end_counter
  FROM Trial
  GROUP BY Name
) c ON c.Name = t.Name

请看演示。
结果：

> Name  | Trial | Start    | End        | Result
> :---- | :---- | :------- | :--------- | :-----
> Emily | A     | Oak St   | Oak St     | No    
> Emily | B     | Oak St   | Elm Rd     | No    
> Frank | A     | Main Ave | Main Ave   | Yes   
> Frank | B     | Main Ave | Main Ave   | Yes   
> Frank | C     | Main Ave | Main Ave   | Yes   
> James | A     | Deer Rd  | Deer Rd    | Yes   
> James | B     | Deer Rd  | Deer Rd    | Yes   
> Jeff  | A     | Main Ave | Main Ave   | No    
> Jeff  | B     | Oak St   | Oak St     | No    
> Julie | A     | Ranch St | Ranch St   | No    
> Julie | B     | Ranch St | North Blvd | No