问基于多行标记实例？

EN

select CLAIMID
    , CLAIMLINE
    , USEMANUAL
    , IsManual.PricingUsed
from Claims c
cross apply
(
    select max(case when USEMANUAL = 'Y' then 'Yes' else 'No' end) as PricingUsed
    from Claims c2
    where c2.CLAIMID = c.CLAIMID
) as IsManual

Declare @YourTable table (ClaimID int,ClaimLine int,UseManual varchar(10))
Insert Into @YourTable values
(12345,1,'N'),
(12345,2,'N'),
(12345,3,'N'),
(12345,4,'Y'),
(12345,5,'N')

Select *
      ,Manual_Priceing_Used = case when max(UseManual) over (Partition By ClaimID)='Y' then 'Yes' else 'No' end
 From  @YourTable

   ClaimID  ClaimLine   UseManual   Manual_Priceing_Used
    12345   1           N           Yes
    12345   2           N           Yes
    12345   3           N           Yes
    12345   4           Y           Yes
    12345   5           N           Yes