求个存储过程~~~谢谢各位大虾~！

[faa171544]

一张表ABC内有4个字段，分别是ID,NAME,PRONAME（产品名称）,ADDRESS。此表里PRONAME有些行是些乱码信息如N/A，凡是出现N/A的，就用上一行的PRONAME进行替换。小弟存储过程实在玩不转，求各位大虾指教12.小弟在此先谢过了。

[sdxiong]

select id,name,case when proname = 'N/A' then (select top 1 proname from test where id<a.id order by id desc) 
                    else proname end as proname,address
from test a

如果是要修改原来的记录,则改成
update a set proname = (select top 1 proname from test where id<a.id order by id desc)
from test a
where proname = 'N/A' 

[-狙击手-]

..

[lanmengxjh]

用case..when..then吧

[jasonren]

case
同一楼.