SQL SERVER 语法问题
create proc tenYuan
@taskID int,
@manID int
as
declare @numebr int
set @numebr=(select COUNT(ID) from dbo.Summit where TaskID=@taskID)
if @numebr=0
begin
update dbo.Man set Price=Price where ID=@manID
end
if @numebr=1
begin
update dbo.Man set Price=Price+10 where ID=@manID
end
if @numebr=2
begin
update dbo.Man set Price=Price+10 where ID=@manID
end
if @numebr>=3
begin
update
(select a.Price from dbo.Man a
left join
(select top 3 ManID from dbo.Summit where TaskID=@taskID order by SummitTime) b
on a.ID=b.ManID)c
set c.Price=c.Price+10
end







这是为什么错呢。。该怎样修改呢、、、

[解决办法]

SQL code

update a set a.Price=a.Price+10from  from dbo.Man a  left join  (select top 3 ManID from dbo.Summit where TaskID=@taskID order by SummitTime) b  on a.ID=b.ManID
[解决办法]
SQL code
update a set a.Price=a.Price+10from dbo.Man a  left join  (select top 3 ManID from dbo.Summit where TaskID=@taskID order by SummitTime) b  on a.ID=b.ManID