问题解决方式: |
第一步:----------------------------首先执行如下脚本,把存储过程删除--------------
/****** 对象: StoredProcedure [dbo].[GL_P_FSEYEB] 脚本日期: 07/20/2013 10:46:05 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GL_P_FSEYEB]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[GL_P_FSEYEB]
第二步:---------------------------再执行如下脚本,把正确的存储过程增加-----------------------
/****** 对象: StoredProcedure [dbo].[GL_P_FSEYEB] 脚本日期: 07/20/2013 10:43:00 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER OFF GO
CREATE Proc [dbo].[GL_P_FSEYEB](@iPer1 varchar(10),@iPer2 varchar(10),@ibk tinyint, @c_code1 varchar(60),@c_code2 varchar(60),@n_jc1 tinyint,@n_jc2 tinyint, @isend tinyint,@kmlx varchar(20) , @exch varchar(20) , @yefw1 varchar(20) ,@yefw2 varchar(20), @kmlxs varchar(500),@TRnd varchar(20)) AS SET NOCOUNT ON declare @ss varchar(8000)
set @ss='TempDB..G'+@TRnd +'A' if not object_id(@ss) is null begin set @ss='DROP TABLE TempDB..G'+@TRnd +'A' exec (@ss) end
set @ss='select ccode into TempDB..G'+@TRnd +'A from code where code.igrade >= ' +convert(char,@n_jc1,0) + ' ' + (case when (@c_code1) is null then '' else ' and code.ccode >= ''' +@c_code1 + ''' ' end)+ (case when (@c_code2) is null then '' else ' and code.ccode <= ''' +@c_code2 + ''' ' end)+ (case when (@n_jc2) =0 then '' else ' and code.igrade <= ' +convert(char,@n_jc2,0) + ' ' end) +(case when (@isend) =0 then '' else ' and code.bend =1 ' end)+ (case when (@kmlx) is null then ' and code.cclass<>''表外科目''' else ' and code.cclass = ''' +@kmlx + ''' ' end)+ (case when (@exch) is null then '' else ' and code.cexch_name= ''' +@exch + ''' ' end)
exec (@ss)
set @ss='TempDB..G'+@TRnd +'C' if not object_id(@ss) is null begin set @ss='DROP TABLE TempDB..G'+@TRnd +'C' exec (@ss) end set @ss='TempDB..G'+@TRnd +'B' if not object_id(@ss) is null begin set @ss='DROP TABLE TempDB..G'+@TRnd +'B' exec (@ss) end
set @ss=' select distinct code.ccode into TempDB..G'+@TRnd +'B from code inner join TempDB..G'+@TRnd +'A on code.ccode like (TempDB..G'+@TRnd +'A.ccode+''%'') where code.bend=1' exec (@ss)
set @ss='TempDB..G'+@TRnd +'D' if not object_id(@ss) is null begin set @ss='DROP TABLE TempDB..G'+@TRnd +'D' exec (@ss) end
if @ibk=0 begin
set @ss=' SELECT gl_accvouch.ccode, Sum(case when (iperiod)<'+@iper1+' then md-mc else 0 end) AS mbb, Sum(case when (iperiod)>='+@iper1+' then md else 0 end) AS mdd, Sum(case when (iperiod)>='+@iper1+' then mc else 0 end) AS mcc, Sum(case when (iperiod)<'+@iper1+' then md_f-mc_f else 0 end) AS mbb_f, Sum(case when (iperiod)>='+@iper1+' then md_f else 0 end ) AS mdd_f, Sum(case when (iperiod)>='+@iper1+' then mc_f else 0 end ) AS mcc_f, Sum(case when (iperiod)<'+@iper1+' then nd_s-nc_s else 0 end) AS mbb_s, Sum(case when (iperiod)>='+@iper1+' then nd_s else 0 end) AS mdd_s, Sum(case when (iperiod)>='+@iper1+' then nc_s else 0 end) AS mcc_s, Sum(md) AS mld, Sum(mc) AS mlc, Sum(md_f) AS mld_f, Sum(mc_f) AS mlc_f, Sum(nd_s) AS mld_s, Sum(nc_s) AS mlc_s into TempDB..G'+@TRnd +'D FROM GL_accvouch inner join TempDB..G'+@TRnd +'B on gl_accvouch.ccode=TempDB..G'+@TRnd +'B.ccode WHERE ibook =0 and iperiod>= 1 and iperiod <= '+@iper2+' and (iflag is null or iflag=2) GROUP BY gl_accvouch.ccode' +' union all '+ 'SELECT gl_accsum.ccode, Sum(case when (iperiod)='+@iper1+' then (case when cbegind_c=''借'' then mb else -mb end) else 0 end) AS mbb, Sum(case when (iperiod)>='+@iper1+' then md else 0 end) AS mdd, Sum(case when (iperiod)>='+@iper1+' then mc else 0 end) AS mcc, Sum(case when (iperiod)='+@iper1+' then (case when cbegind_c=''贷'' then -mb_f else mb_f end ) else 0 end) AS mbb_f, Sum(case when (iperiod)>='+@iper1+' then md_f else 0 end ) AS mdd_f, Sum(case when (iperiod)>='+@iper1+' then mc_f else 0 end ) AS mcc_f, Sum(case when (iperiod)='+@iper1+' then (case when cbegind_c=''贷'' then -nb_s else nb_s end ) else 0 end) AS mbb_s, Sum(case when (iperiod)>='+@iper1+' then nd_s else 0 end) AS mdd_s, Sum(case when (iperiod)>='+@iper1+' then nc_s else 0 end) AS mcc_s, Sum(md) AS mld, Sum(mc) AS mlc, Sum(md_f) AS mld_f, Sum(mc_f) AS mlc_f, Sum(nd_s) AS mld_s, Sum(nc_s) AS mlc_s FROM GL_accsum inner join TempDB..G'+@TRnd +'B on gl_accsum.ccode=TempDB..G'+@TRnd +'B.ccode WHERE iperiod <= '+@iper2+' GROUP BY gl_accsum.ccode' exec (@ss)
set @ss= 'SELECT code.ccode as ccode, sum(TempDB..G'+@TRnd +'D.mbb) as mbb, sum(TempDB..G'+@TRnd +'D.mdd) as mdd, sum(TempDB..G'+@TRnd +'D.mcc) as mcc, sum(TempDB..G'+@TRnd +'D.mld) as mld, sum(TempDB..G'+@TRnd +'D.mlc) as mlc, sum(TempDB..G'+@TRnd+'D.mbb_f) as mbb_f, sum(TempDB..G'+@TRnd+'D.mdd_f) as mdd_f, sum(TempDB..G'+@TRnd+'D.mcc_f) as mcc_f, sum(TempDB..G'+@TRnd+'D.mld_f) as mld_f, sum(TempDB..G'+@TRnd+'D.mlc_f) as mlc_f, sum(TempDB..G'+@TRnd +'D.mbb_s) as mbb_s, sum(TempDB..G'+@TRnd +'D.mdd_s) as mdd_s, sum(TempDB..G'+@TRnd +'D.mcc_s) as mcc_s, sum(TempDB..G'+@TRnd +'D.mld_s) as mld_s, sum(TempDB..G'+@TRnd +'D.mlc_s) as mlc_s into TempDB..G'+@TRnd +'C FROM code inner join TempDB..G'+@TRnd +'D on TempDB..G'+@TRnd + 'D.ccode like (code.ccode + ''%'') GROUP BY code.ccode' end
else
begin set @ss=' SELECT gl_accsum.ccode, Sum(case when (iperiod)='+@iper1+' then (case when cbegind_c=''借'' then mb else -mb end) else 0 end) AS mbb, Sum(case when (iperiod)>='+@iper1+' then md else 0 end) AS mdd, Sum(case when (iperiod)>='+@iper1+' then mc else 0 end) AS mcc, Sum(case when (iperiod)='+@iper1+' then (case when cbegind_c=''贷'' then -mb_f else mb_f end ) else 0 end) AS mbb_f, Sum(case when (iperiod)>='+@iper1+' then md_f else 0 end ) AS mdd_f, Sum(case when (iperiod)>='+@iper1+' then mc_f else 0 end ) AS mcc_f, Sum(case when (iperiod)='+@iper1+' then (case when cbegind_c=''贷'' then -nb_s else nb_s end ) else 0 end) AS mbb_s, Sum(case when (iperiod)>='+@iper1+' then nd_s else 0 end) AS mdd_s, Sum(case when (iperiod)>='+@iper1+' then nc_s else 0 end) AS mcc_s, Sum(md) AS mld, Sum(mc) AS mlc, Sum(md_f) AS mld_f, Sum(mc_f) AS mlc_f, Sum(nd_s) AS mld_s, Sum(nc_s) AS mlc_s into TempDB..G'+@TRnd +'D FROM GL_accsum inner join TempDB..G'+@TRnd +'B on gl_accsum.ccode=TempDB..G'+@TRnd +'B.ccode WHERE iperiod <= '+@iper2+' GROUP BY gl_accsum.ccode' exec (@ss)
set @ss= 'SELECT code.ccode as ccode, sum(TempDB..G'+@TRnd +'D.mbb) as mbb, sum(TempDB..G'+@TRnd +'D.mdd) as mdd, sum(TempDB..G'+@TRnd +'D.mcc) as mcc, sum(TempDB..G'+@TRnd +'D.mld) as mld, sum(TempDB..G'+@TRnd +'D.mlc) as mlc, sum(TempDB..G'+@TRnd+'D.mbb_f) as mbb_f, sum(TempDB..G'+@TRnd+'D.mdd_f) as mdd_f, sum(TempDB..G'+@TRnd+'D.mcc_f) as mcc_f, sum(TempDB..G'+@TRnd+'D.mld_f) as mld_f, sum(TempDB..G'+@TRnd+'D.mlc_f) as mlc_f, sum(TempDB..G'+@TRnd +'D.mbb_s) as mbb_s, sum(TempDB..G'+@TRnd +'D.mdd_s) as mdd_s, sum(TempDB..G'+@TRnd +'D.mcc_s) as mcc_s, sum(TempDB..G'+@TRnd +'D.mld_s) as mld_s, sum(TempDB..G'+@TRnd +'D.mlc_s) as mlc_s into TempDB..G'+@TRnd +'C FROM code inner join TempDB..G'+@TRnd +'D on TempDB..G'+@TRnd + 'D.ccode like (code.ccode + ''%'') GROUP BY code.ccode' end exec (@ss) ----------------------------------------------- set @ss='TempDB..G'+@TRnd +'B' if not object_id(@ss) is null begin set @ss='DROP TABLE TempDB..G'+@TRnd+'B' exec (@ss) end if not @yefw1 is null or not @yefw2 is null begin set @ss='select TempDB..G'+@TRnd +'C.ccode into TempDB..G'+@TRnd +'B from TempDB..G'+@TRnd +'C inner join TempDB..G'+@TRnd +'A on TempDB..G'+@TRnd +'A.ccode=TempDB..G'+@TRnd +'C.ccode where ' +case when @yefw1 is null then '' else ' ABS(TempDB..G'+@TRnd +'C.mbb+TempDB..G'+@TRnd+'C.mdd-TempDB..G'+@TRnd+'C.mcc)>='+@yefw1 end +case when @yefw2 is null then '' else case when @yefw1 is null or @yefw1='' then '' else ' and ' end +' ABS(TempDB..G'+@TRnd +'C.mbb+TempDB..G'+@TRnd+'C.mdd-TempDB..G'+@TRnd+'C.mcc)<='+@yefw2 end exec (@ss) end else begin set @ss= 'SELECT TempDB..G'+@TRnd +'A.ccode into TempDB..G'+@TRnd +'B FROM TempDB..G'+@TRnd +'A ' exec (@ss) end
---------------------------------- --======================================================== --yxw 因为小于0的条件没有问题,所以针对大于0时把A表不满足条件的科目去掉,避免重复相加。 set @ss='TempDB..G'+@TRnd +'G' if not object_id(@ss) is null begin set @ss='DROP TABLE TempDB..G'+@TRnd+'G' exec (@ss) end set @ss='TempDB..G'+@TRnd +'H' if not object_id(@ss) is null begin set @ss='DROP TABLE TempDB..G'+@TRnd+'H' exec (@ss) end if not @yefw1 is null begin set @ss='select TempDB..G'+@TRnd +'C.ccode into TempDB..G'+@TRnd +'G from TempDB..G'+@TRnd +'C inner join TempDB..G'+@TRnd +'A on TempDB..G'+@TRnd +'A.ccode=TempDB..G'+@TRnd +'C.ccode where ' +' ABS(TempDB..G'+@TRnd +'C.mbb+TempDB..G'+@TRnd+'C.mdd-TempDB..G'+@TRnd+'C.mcc)>='+@yefw1 exec (@ss) set @ss='select * into TempDB..G'+@TRnd +'H from TempDB..G'+@TRnd +'A where TempDB..G'+@TRnd +'A.ccode not in (select * from TempDB..G'+@TRnd +'G)' exec (@ss) set @ss='TempDB..G'+@TRnd +'A' if not object_id(@ss) is null begin set @ss='DROP TABLE TempDB..G'+@TRnd+'A' exec (@ss) end set @ss='select * into TempDB..G'+@TRnd+'A from TempDB..G'+@TRnd +'G' exec (@ss) end --======================================================== set @ss='TempDB..G'+@TRnd +'D' if not object_id(@ss) is null begin set @ss='DROP TABLE TempDB..G'+@TRnd+'D' exec (@ss) end set @ss='select TempDB..G'+@TRnd +'A.ccode,count(*) as bs into TempDB..G'+@TRnd + 'D from TempDB..G'+@TRnd +'A inner join TempDB..G'+@TRnd +'B on TempDB..G'+@TRnd + 'A.ccode like (TempDB..G'+@TRnd+'B.ccode+''%'') group by TempDB..G'+@TRnd +'A.ccode' exec (@ss)
set @ss='TempDB..G'+@TRnd +'A' if not object_id(@ss) is null begin set @ss='DROP TABLE TempDB..G'+@TRnd+'A' exec (@ss) end set @ss='SELECT code.ccode into TempDB..G'+@TRnd +'A FROM code inner join TempDB..G'+@TRnd +'B on TempDB..G'+@TRnd +'B.ccode=code.ccode where not code.cexch_name is null' exec (@ss)
set @ss='TempDB..G'+@TRnd +'E' if not object_id(@ss) is null begin set @ss='DROP TABLE TempDB..G'+@TRnd+'E' exec (@ss) end set @ss= 'SELECT TempDB..G'+@TRnd +'A.ccode into TempDB..G'+@TRnd +'E FROM TempDB..G'+@TRnd +'A ' exec (@ss)
set @ss='TempDB..G'+@TRnd +'F' if not object_id(@ss) is null begin set @ss='DROP TABLE TempDB..G'+@TRnd+'F' exec (@ss) end set @ss='select TempDB..G'+@TRnd +'A.ccode,count(*) as bs into TempDB..G'+@TRnd + 'F from TempDB..G'+@TRnd +'A inner join TempDB..G'+@TRnd +'E on TempDB..G'+@TRnd + 'A.ccode like (TempDB..G'+@TRnd+'E.ccode+''%'') group by TempDB..G'+@TRnd +'A.ccode' exec (@ss)
set @ss= 'SELECT ' +@kmlxs + ',code.ccode,code.ccode_name,code.cexch_name, sum(case when TempDB..G'+@TRnd +'C.mbb>0 then TempDB..G'+@TRnd +'C.mbb else 0 end) as sbb, sum(case when TempDB..G'+@TRnd +'C.mbb>0 then 0 else ABS(TempDB..G'+@TRnd +'C.mbb) end) as sbb1, sum(TempDB..G'+@TRnd +'C.mdd) as smd,sum(TempDB..G'+@TRnd +'C.mcc) as smc, sum(TempDB..G'+@TRnd +'C.mld) as sld,sum(TempDB..G'+@TRnd +'C.mlc) as slc, sum(case when TempDB..G'+@TRnd +'C.mbb+TempDB..G'+@TRnd +'C.mdd-TempDB..G'+@TRnd +'C.mcc>0 then TempDB..G'+@TRnd +'C.mbb+TempDB..G'+@TRnd +'C.mdd-TempDB..G'+@TRnd +'C.mcc else 0 end) as smm, sum(case when TempDB..G'+@TRnd +'C.mbb+TempDB..G'+@TRnd +'C.mdd-TempDB..G'+@TRnd +'C.mcc>0 then 0 else ABS(TempDB..G'+@TRnd +'C.mbb+TempDB..G'+@TRnd +'C.mdd-TempDB..G'+@TRnd +'C.mcc) end) as smm1, sum(case when (code.cexch_name) is null then 0 else TempDB..G'+@TRnd+'C.mbb_f end) as sbb_f, sum(case when (code.cexch_name) is null then 0 else TempDB..G'+@TRnd+'C.mdd_f end) as smd_f, sum(case when (code.cexch_name) is null then 0 else TempDB..G'+@TRnd+'C.mcc_f end) as smc_f, sum(case when (code.cexch_name) is null then 0 else TempDB..G'+@TRnd+'C.mld_f end) as sld_f, sum(case when (code.cexch_name) is null then 0 else TempDB..G'+@TRnd+'C.mlc_f end) as slc_f, sum(case when (code.cexch_name) is null then 0 else TempDB..G'+@TRnd +'C.mbb_f+TempDB..G'+@TRnd +'C.mdd_f-TempDB..G'+@TRnd +'C.mcc_f end) as smm_f, sum(case when (code.cmeasure) is null then 0 else TempDB..G'+@TRnd +'C.mbb_s end) as sbb_s, sum(case when (code.cmeasure) is null THEN 0 else TempDB..G'+@TRnd +'C.mdd_s end) as smd_s, sum(case when (code.cmeasure) is null then 0 else TempDB..G'+@TRnd +'C.mcc_s end) as smc_s, sum(case when (code.cmeasure) is null THEN 0 else TempDB..G'+@TRnd +'C.mld_s end) as sld_s, sum(case when (code.cmeasure) is null then 0 else TempDB..G'+@TRnd +'C.mlc_s end) as slc_s, sum(case when (code.cmeasure) is null then 0 else TempDB..G'+@TRnd +'C.mbb_s+TempDB..G'+@TRnd +'C.mdd_s-TempDB..G'+@TRnd +'C.mcc_s end) as smm_s FROM code inner join TempDB..G'+@TRnd +'C ON TempDB..G'+@TRnd +'C.ccode=code.ccode inner join TempDB..G'+@TRnd +'B on code.ccode=TempDB..G'+@TRnd +'B.ccode GROUP BY code.cclass,code.ccode,code.ccode_name,code.cexch_name' +' union all '+ 'SELECT '+@kmlxs+',''zz'' as ccode, '''' as ccode_name,'''' as cexch_name, sum(case when TempDB..G'+@TRnd +'C.mbb>0 then TempDB..G'+@TRnd +'C.mbb else 0 end) as sbb, sum(case when TempDB..G'+@TRnd +'C.mbb>0 then 0 else ABS(TempDB..G'+@TRnd +'C.mbb) end) as sbb1, sum(TempDB..G'+@TRnd +'C.mdd) as smd,sum(TempDB..G'+@TRnd +'C.mcc) as smc, sum(TempDB..G'+@TRnd +'C.mld) as sld,sum(TempDB..G'+@TRnd +'C.mlc) as slc, sum(case when TempDB..G'+@TRnd +'C.mbb+TempDB..G'+@TRnd +'C.mdd-TempDB..G'+@TRnd +'C.mcc>0 then TempDB..G'+@TRnd +'C.mbb+TempDB..G'+@TRnd +'C.mdd-TempDB..G'+@TRnd +'C.mcc else 0 end) as smm, sum(case when TempDB..G'+@TRnd +'C.mbb+TempDB..G'+@TRnd +'C.mdd-TempDB..G'+@TRnd +'C.mcc>0 then 0 else ABS(TempDB..G'+@TRnd +'C.mbb+TempDB..G'+@TRnd +'C.mdd-TempDB..G'+@TRnd +'C.mcc) end) as smm1, 0 as sbb_f, 0 as smd_f, 0 as smc_f, 0 as sld_f, 0 as slc_f, 0 as smm_f, 0 as sbb_s, 0 as smd_s, 0 as smc_s, 0 as sld_s, 0 as slc_s, 0 as smm_s FROM TempDB..G'+@TRnd +'C inner join (code inner join TempDB..G'+@TRnd +'D ON code.ccode =TempDB..G'+@TRnd +'D.ccode) ON code.ccode=TempDB..G'+@TRnd+'C.ccode where TempDB..G'+@TRnd +'D.bs=1 GROUP BY code.cclass ' +'union all '+ 'SELECT ' +@kmlxs+ ', ''zzzz''+code.cexch_name as ccode, '''' as ccode_name,'''' as cexch_name, 0 as sbb,0 as sbb1, 0 as smd, 0 as smc, 0 as sld, 0 as slc, 0 as smm, 0 as smm1, sum(TempDB..G'+@TRnd+'C.mbb_f) as sbb_f, sum(TempDB..G'+@TRnd+'C.mdd_f) as smd_f, sum(TempDB..G'+@TRnd+'C.mcc_f) as smc_f, sum(TempDB..G'+@TRnd+'C.mld_f) as sld_f, sum(TempDB..G'+@TRnd+'C.mlc_f) as slc_f, sum(TempDB..G'+@TRnd +'C.mbb_f+TempDB..G'+@TRnd +'C.mdd_f-TempDB..G'+@TRnd +'C.mcc_f) as smm_f, 0 as sbb_s, 0 as smd_s, 0 as smc_s, 0 as sld_s, 0 as slc_s, 0 as smm_s FROM TempDB..G'+@TRnd +'C inner join code inner join TempDB..G'+@TRnd +'F ON code.ccode =TempDB..G'+@TRnd +'F.ccode ON code.ccode=TempDB..G'+@TRnd+'C.ccode '+ 'where TempDB..G'+@TRnd +'F.bs=1'+ 'GROUP BY code.cclass,code.cexch_name' +' union all SELECT 9 as lx,''zz'' as ccode, '''' as ccode_name,'''' as cexch_name, sum(case when TempDB..G'+@TRnd +'C.mbb>0 then TempDB..G'+@TRnd +'C.mbb else 0 end) as sbb, sum(case when TempDB..G'+@TRnd +'C.mbb>0 then 0 else ABS(TempDB..G'+@TRnd +'C.mbb) end) as sbb1, sum(TempDB..G'+@TRnd +'C.mdd) as smd,sum(TempDB..G'+@TRnd +'C.mcc) as smc, sum(TempDB..G'+@TRnd +'C.mld) as sld,sum(TempDB..G'+@TRnd +'C.mlc) as slc, sum(case when TempDB..G'+@TRnd +'C.mbb+TempDB..G'+@TRnd +'C.mdd-TempDB..G'+@TRnd +'C.mcc>0 then TempDB..G'+@TRnd +'C.mbb+TempDB..G'+@TRnd +'C.mdd-TempDB..G'+@TRnd +'C.mcc else 0 end) as smm, sum(case when TempDB..G'+@TRnd +'C.mbb+TempDB..G'+@TRnd +'C.mdd-TempDB..G'+@TRnd +'C.mcc>0 then 0 else ABS(TempDB..G'+@TRnd +'C.mbb+TempDB..G'+@TRnd +'C.mdd-TempDB..G'+@TRnd +'C.mcc) end) as smm1, 0 as sbb_f, 0 as smd_f, 0 as smc_f, 0 as sld_f, 0 as slc_f, 0 as smm_f, 0 as sbb_s, 0 as smd_s, 0 as smc_s, 0 as sld_s, 0 as slc_s, 0 as smm_s FROM TempDB..G'+@TRnd +'C inner join TempDB..G'+@TRnd +'D ON TempDB..G'+@TRnd +'C.ccode=TempDB..G'+@TRnd +'D.ccode where TempDB..G'+@TRnd +'D.bs=1 ' +'union all '+ 'SELECT 9 as lx, ''zzzz''+code.cexch_name as ccode, '''' as ccode_name,'''' as cexch_name, 0 as sbb,0 as sbb1, 0 as smd, 0 as smc, 0 as sld, 0 as slc, 0 as smm, 0 as smm1, sum(TempDB..G'+@TRnd+'C.mbb_f) as sbb_f, sum(TempDB..G'+@TRnd+'C.mdd_f) as smd_f, sum(TempDB..G'+@TRnd+'C.mcc_f) as smc_f, sum(TempDB..G'+@TRnd+'C.mld_f) as sld_f, sum(TempDB..G'+@TRnd+'C.mlc_f) as slc_f, sum(TempDB..G'+@TRnd +'C.mbb_f+TempDB..G'+@TRnd +'C.mdd_f-TempDB..G'+@TRnd +'C.mcc_f) as smm_f, 0 as sbb_s, 0 as smd_s, 0 as smc_s, 0 as sld_s, 0 as slc_s, 0 as smm_s FROM TempDB..G'+@TRnd +'C inner join code inner join TempDB..G'+@TRnd +'F ON code.ccode=TempDB..G'+@TRnd +'F.ccode ON code.ccode=TempDB..G'+@TRnd +'C.ccode where TempDB..G'+@TRnd +'F.bs=1'+ 'GROUP BY code.cexch_name order by lx,code.ccode '
exec (@ss)
set @ss='TempDB..G'+@TRnd +'A' if not object_id(@ss) is null begin set @ss='DROP TABLE TempDB..G'+@TRnd+'A' exec (@ss) end
set @ss='TempDB..G'+@TRnd +'B' if not object_id(@ss) is null begin set @ss='DROP TABLE TempDB..G'+@TRnd+'B' exec (@ss) end
set @ss='TempDB..G'+@TRnd +'C' if not object_id(@ss) is null begin set @ss='DROP TABLE TempDB..G'+@TRnd+'C' exec (@ss) end
set @ss='TempDB..G'+@TRnd +'D' if not object_id(@ss) is null begin set @ss='DROP TABLE TempDB..G'+@TRnd+'D' exec (@ss) end
set @ss='TempDB..G'+@TRnd +'E' if not object_id(@ss) is null begin set @ss='DROP TABLE TempDB..G'+@TRnd+'E' exec (@ss) end
set @ss='TempDB..G'+@TRnd +'F' if not object_id(@ss) is null begin set @ss='DROP TABLE TempDB..G'+@TRnd+'F' exec (@ss) end
set @ss='TempDB..G'+@TRnd +'G' if not object_id(@ss) is null begin set @ss='DROP TABLE TempDB..G'+@TRnd+'G' exec (@ss) end
set @ss='TempDB..G'+@TRnd +'H' if not object_id(@ss) is null begin set @ss='DROP TABLE TempDB..G'+@TRnd+'H' exec (@ss) end
|