如题请高手指点 附升级日志:
'j\~> a3\ 其中 wbs_fullcode 是什么?因该是列名吧?
i<M
F8$ @@@@@@@@@@@@@@@@@@@@@@@
a] P0PH~ CREATE procedure KB_Tur_equipment(@project_names varchar(8000))
Sg<
B+u\\ AS
gn:&akg !>?*gc.< declare @epstype varchar(50)
iBk1QRdn declare @projectid varchar(30)
avY<~-44B declare @sql varchar(8000)
bl-
D{)X if object_id('tempdb.dbo.#t') is not null
eWr2UX
v$ drop table #t
mq+x= create table #t( seq int IDENTITY (1, 1) NOT NULL,equiparea varchar(100) null ,equipcode varchar(100),equipname VARCHAR(100),wbs_fullcode varchar(150) )
v+~O\v5Q set @sql = ' alter table #t add '
=C-
b#4Q declare cur_ cursor for select epstype,project_id from rec_querylink where funcname like '汽管相关设备工程量%'
a(AYY<g open cur_
g'NR
\<6A fetch cur_ into @epstype,@projectid
[
ZL<Q while @@fetch_status = 0
K(AZD&D
begin
s;#,c( set @sql = @sql + ' ['+@epstype + '] float null,'
G5NAwpZf )T@?.J` fetch cur_ into @epstype,@projectid
Q>I7.c-M| end
_q}^#- close cur_
_~ 3r*j deallocate cur_
k54b@U52 h set @sql = substring(@sql,1,len(@sql)-1)
ZyV^d3F@$ print (@sql)
gkDXt^Ob if right(@sql,2)<>'ad'
Yv3P]6c. exec (@sql)
NbK67p: set @sql = ' alter table #t add 总重 float '
|(=b --exec (@sql)
Y+gNi_dE insert #t(equiparea,equipcode,equipname,wbs_fullcode)
juQ?k xOB select distinct equiparea,equipcode,equipname,wbs_fullcode from view_tur_sum_equip
v?l*jr1-2 Hq|{Nt%Q declare cur_ cursor for select epstype,project_id from rec_querylink where funcname like '汽管相关设备工程量%'
G[]h1f! open cur_
$49;\pBZ
l fetch cur_ into @epstype,@projectid
C?]+(P while @@fetch_status = 0
-HRa6 begin
F1/BtGvQE 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 '
.SDE6nvbW set @sql = @sql + ' from view_tur_sum_equip '
|<#yXSi set @sql = @sql + ' where
project_id='''+@projectid+''' group by project_id, equiparea,equipcode,equipname,wbs_fullcode ) a '
\q"vC1,9 +' where #t.equiparea=a.equiparea and #t.equipcode=a.equipcode and #t.equipname=a.equipname and #t.wbs_fullcode=a.wbs_fullcode '
dvLL~VP exec (@sql)
Ue=1NnRDkA fetch cur_ into @epstype,@projectid
7! ~)a end
oN,9#*PVL close cur_
REPI>-| deallocate cur_
Y ^5RM select * from #t
/}(\P@Z 错误信息:
cRSgP{hy 列名 'wbs_fullcode' 无效。
5>-~!Mg1 #KDN 升级失败,还原老版本的数据库成功!2009-1-4 18:59:05
8aVj@x$'