帮忙也个update ,把表A uid改成表B相同name下uid最大的。谢谢

[hleb231]

if OBJECT_ID('tempdb..#A') is not null
drop table #A
if OBJECT_ID('tempdb..#B') is not null
drop table #B
create table #A 
(
uid int 
)
insert into #A
select 1 union all
select 10 union all
select 10 union all
select 1 union all
select 8 union all
select 8 union all
select 35 
go
create table #B
(
uid int ,
name varchar(10)
)
insert into #B
select 1,'AA' union all
select 10,'AA' union all
select 8,'BB' union all
select 35,'BB' 
go

[hleb231]

分太少了么，我已经6年没写过SQL。效率【face]onion:3.gif[/face]

[二月十六]

;WITH cte AS (
SELECT #A.uid,name FROM #A  JOIN #B ON #B.uid = #A.uid
)
UPDATE cte SET cte.uid=t.uid FROM (SELECT name,MAX(uid) AS uid FROM #B GROUP BY name)t WHERE cte.name=t.name

SELECT * FROM #A