Shruti ..

尝试以下代码块

Hi Shruti ..

Try the following code block

 WITH OACTE AS (
  SELECT O.Owner,O.Domain,A.Center,O.Id,ROW_NUMBER()
  OVER (PARTITION BY O.Owner,O.Id ORDER BY O.Id) ROWNUM
  FROM Owner O JOIN Asset A ON O.Domain = A.Asset
)

SELECT Owner,Domain,CASE WHEN ROWNUM > 1 THEN
 (SELECT TOP 1 Center FROM OACTE WHERE Owner = OA.Owner AND Id = OA.ID)
 ELSE OA.Center END As Center  FROM OACTE As OA

谢谢

Thank you

尝试一下

try this

update ao
set
ao.Center=a.center
from AssetOwner ao
join asset a1 on a1.asset=ao.Asset
join owner o1 on o1.Owner=ao.owner and a1.Asset=o1.Domain
join owner o2 on o1.owner=o2.owner and o1.Id=o2.Id and  o1.Owner=ao.owner
join asset a on a.possition=o1.position
where o1.domain=(select top 1 domain from  owner where id=o1.id and owner=o1.Owner)

我希望这对您有用

i hope this will work for you