@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
