简单的存储过程问题 帮帮我

[javabuilder9]

ALTER PROCEDURE AddReportShengChanCount_Month
@ID varchar(300),
@DepartmentID varchar(300),
@Year varchar(50),
@Month varchar(50)
AS
DECLARE @sql varchar(4000)

set @ID = substring(@ID, 2, len(@ID)-1)

insert into T_Report_ShengChan_Count_Month
select
@DepartmentID,@Year,@Month,
sum(dltdsgm),
sum(dltdswm),
sum(dlzdsgm),
sum(dlzdswm),
sum(dlqbsgm),
sum(dlqbswm),
sum(dlqbssm),
sum(dlqbsunshim),
sum(slzdsgm),
sum(slzdswm),
sum(sldsgm),
sum(sldsgswm),
sum(slqbsgm),
sum(slqbswm),
sum(slqbssm),

sum(slsunshim) from T_Report_ShengChan_All
Where ',' + @ID + ',' Like '%,' + Cast(ID As Varchar) + ',%'
改写该存储过程为update T_Report_ShengChan_Count_Month where [Year]=@Year,[Month]=@Month

[javabuilder9]

就是根据一个相同的表更新本表的代码

[javabuilder9]

ALTER PROCEDURE AddReportShengChanCount_Month
@ID varchar(300),
@DepartmentID varchar(300),
@Year varchar(50),
@Month varchar(50)
AS
DECLARE @sql varchar(4000)

set @ID = substring(@ID, 2, len(@ID)-1)


Update T_Report_ShengChan_Count_Month set
'select
sum(dltdsgm),
sum(dltdswm),
sum(dlzdsgm),
sum(dlzdswm),
sum(dlqbsgm),
sum(dlqbswm),
sum(dlqbssm),
sum(dlqbsunshim),
sum(slzdsgm),
sum(slzdswm),
sum(sldsgm),
sum(sldsgswm),
sum(slqbsgm),
sum(slqbswm),
sum(slqbssm),
sum(slsunshim) from T_Report_ShengChan_All
Where ',' + @ID + ',' Like '%,' + Cast(ID As Varchar) + ',%' 'where [Year]=@Year,[Month]=@Month
修改这个存储过程

[yangjia21_2007]

啥意思啊？

[songle912]

楼主，太懒了吧，自己不动手，永远都要靠别人的，Update也要别人帮？自己仔细去调吧

[javabuilder9]

帮我修改下面这个存储过程 有错误 我解决不了
ALTER PROCEDURE UpdateReportShengChanCount_Month
@ID varchar(300),
@DepartmentID varchar(300),
@Year varchar(50),
@Month varchar(50)
AS
DECLARE @sql varchar(4000)

set @ID = substring(@ID, 2, len(@ID)-1)


Update T_Report_ShengChan_Count_Month set
'select
sum(dltdsgm),
sum(dltdswm),
sum(dlzdsgm),
sum(dlzdswm),
sum(dlqbsgm),
sum(dlqbswm),
sum(dlqbssm),
sum(dlqbsunshim),
sum(slzdsgm),
sum(slzdswm),
sum(sldsgm),
sum(sldsgswm),
sum(slqbsgm),
sum(slqbswm),
sum(slqbssm),
sum(slsunshim) from T_Report_ShengChan_All
Where ',' + @ID + ',' Like '%,' + Cast(ID As Varchar) + ',%' 'where [Year]=@Year,[Month]=@Month

[javabuilder9]

我实在是解决不了啊 帮帮我吧 大家