帮帮忙 拜托

[diandianfei]

编写一段程序，将每种玩具的价格提高￥0.5，直到玩具的平均价格接近$24.5为止。此外，任何玩具的最大价格不应超过$53。
要用存储过程

[zheninchangjiang]

declare @i int
set @i=1
while @i=1
update tablename set price=price+0.5 where price<53-0.5

[zheninchangjiang]

--按错了,接着
declare @i int
set @i=1
while @i=1
begin
update tablename set price=price+0.5 where price<53-0.5

if cast((select avg(price) from tablename)/0.5 as int)=cast(24.5/0.5 as int)
@i=0
end

[chludlf]

while (select sum(price)/sum(1) from table )<24.5
begin
update table set price = case when price<53 then price*1.5 else price end

update table set price=49.5 where price>53
end

[chludlf]

while (select sum(price)/sum(1) from table )<24.5
begin
update table set price = case when price<53 then price+0.5 else price end

update table set price=49.5 where price>53
end

[berylw]

while(select avg(价格) from 表)<24.5
begin
update 表 set 价格=价格+0.5
if(select max(价格)+0.5 from 表)>53
break
else
continue
end


揭贴吧，完全正确，并且是最简练清晰的

[diandianfei]

谢谢大家 太感动了

[gaurence]

有价值！