如题请高手指点 附升级日志:
dk
nM| 其中 wbs_fullcode 是什么?因该是列名吧?
Um{) ?1 @@@@@@@@@@@@@@@@@@@@@@@
j?m(l,YD|* CREATE procedure KB_Tur_equipment(@project_names varchar(8000))
L"vrX AS
`G1"&q,i cZ|*Zpk declare @epstype varchar(50)
gv>DOez/ declare @projectid varchar(30)
))f@9m declare @sql varchar(8000)
I3Z?xsa@Z if object_id('tempdb.dbo.#t') is not null
r9WR1&T) drop table #t
L?+N:
G
create table #t( seq int IDENTITY (1, 1) NOT NULL,equiparea varchar(100) null ,equipcode varchar(100),equipname VARCHAR(100),wbs_fullcode varchar(150) )
Lv['/!DJ| set @sql = ' alter table #t add '
x\8g ICf declare cur_ cursor for select epstype,project_id from rec_querylink where funcname like '汽管相关设备工程量%'
(m:Q'4Ep open cur_
T&dNjx fetch cur_ into @epstype,@projectid
<q!HY~"V while @@fetch_status = 0
5?SE?VC=t begin
Awxm[:r>^ set @sql = @sql + ' ['+@epstype + '] float null,'
t2)uJN`a$X
94PI fetch cur_ into @epstype,@projectid
X-((
[A end
Ft11?D
B close cur_
n'^`;-
deallocate cur_
Ve%ua]qA set @sql = substring(@sql,1,len(@sql)-1)
,]wQ]fpt print (@sql)
M?sax+' if right(@sql,2)<>'ad'
J{dO0!7y exec (@sql)
JseKqJ
?g set @sql = ' alter table #t add 总重 float '
&?bsBqpN --exec (@sql)
gU+yqT7= insert #t(equiparea,equipcode,equipname,wbs_fullcode)
?wG select distinct equiparea,equipcode,equipname,wbs_fullcode from view_tur_sum_equip
b'+Wf#.]f0 RNw#sR
declare cur_ cursor for select epstype,project_id from rec_querylink where funcname like '汽管相关设备工程量%'
;%2+Tc-7I open cur_
,= ApnNUgX fetch cur_ into @epstype,@projectid
1$03:ve1 while @@fetch_status = 0
'XKfKv >; begin
A+M4= set @sql = 'update #t set ['+@epstype+']=isnull(['+@epstype+'],0)+a.num from (select project_id, equiparea,equipcode,equipname,wbs_fullcode,sum(isnull(weight,0)) as num '
)uHat# set @sql = @sql + ' from view_tur_sum_equip '
h SS9mQ set @sql = @sql + ' where
project_id='''+@projectid+''' group by project_id, equiparea,equipcode,equipname,wbs_fullcode ) a '
cQ- #] +' where #t.equiparea=a.equiparea and #t.equipcode=a.equipcode and #t.equipname=a.equipname and #t.wbs_fullcode=a.wbs_fullcode '
Tdh.U{Nz exec (@sql)
\Qah*1 fetch cur_ into @epstype,@projectid
D.{vuftu end
$!9U\Au>2 close cur_
Z1q<) O1QX deallocate cur_
q[qX O5 select * from #t
lH_pG ~ 错误信息:
E]~#EFc 列名 'wbs_fullcode' 无效。
/'DAB** !1R?3rVQS 升级失败,还原老版本的数据库成功!2009-1-4 18:59:05
"6%{#TZ