sql实现把某一列的值当成列名来实现（待整理完善）

Create PROCEDURE [dbo].[Pro_Number_FactoryA] (     @DATADate        nvarchar(10) )  AS BEGIN          --存储当月天数日期的表     if object_id('tempdb..#tempTableDate') is not null Begin         drop table #tempTableDate     End         create table #tempTableDate --创建临时表     (         StrsDate   varchar(12)     )

    --判断是指定日期还是不区分日期     if(@DATADate='0000')     begin

        --获得当前月份的工厂             SELECT distinct FactoryCode FROM [KhaosReport].[dbo].[T_Khaos_Number_Factory] where DataTime like '%'+@DATADate+'%'                  end     else     begin

    --==============================================创建存储数据表  Start=============================================================              --创建当月数据表         if object_id('tempdb..#tempTableA') is not null Begin             drop table #tempTableA         End             --创建当月数据表         if object_id('tempdb..#tempTableB') is not null Begin             drop table #tempTableB         End                 --创建当月数据表         if object_id('tempdb..#tempTableC') is not null Begin             drop table #tempTableC         End            

        create table #tempTableA --创建临时表         (             FactoryCode   varchar(8),             FactoryName    varchar(80),             FactoryType    varchar(3),             Parent_Factory    varchar(8),             TypeCode    varchar(80)         )              --通过工厂获得指定月份数据             Declare @DataTimeA varchar(10)              --循环日期         DECLARE cursor_nameDate CURSOR FOR --定义游标                  --SELECT distinct DataTime FROM [KhaosReport].[dbo].[T_Khaos_Number_Factory] where DataTime like '%2022-10%'             SELECT distinct DataTime FROM [KhaosReport].[dbo].[T_Khaos_Number_Factory] where DataTime like '%'+@DATADate+'%'

        OPEN cursor_nameDate --打开游标         FETCH NEXT FROM cursor_nameDate INTO  @DataTimeA--抓取下一行游标数据         WHILE @@FETCH_STATUS = 0             BEGIN                      --给临时表增加日期字段                 DECLARE @ColumnName NVARCHAR(100)                 SET @ColumnName ='[' +CONVERT(NVARCHAR(100),@DataTimeA) + ']' 

                --把日期存储到日期表中，后续会用到                 insert into #tempTableDate(StrsDate) values(@ColumnName)

                EXECUTE('ALTER TABLE #tempTableA ADD  ' + @ColumnName + ' NVARCHAR(100)')

                FETCH NEXT FROM cursor_nameDate INTO @DataTimeA             END         CLOSE cursor_nameDate --关闭游标         DEALLOCATE cursor_nameDate --释放游标

    --==============================================创建存储数据表  End=============================================================     --存储上一级数据结构表创建     select * into #tempTableB from #tempTableA     select * into #tempTableC from #tempTableA

    --==============================================数据存储操作  Start=============================================================

        --获得当前月份的工厂         --insert into #tempTableA         --SELECT distinct FactoryCode FROM [KhaosReport].[dbo].[T_Khaos_Number_Factory] where DataTime like '%'+@DATADate+'%'

        --通过工厂获得指定月份数据             Declare @FactoryCodeA varchar(8)

        --获得当前月份的工厂,循环单位         DECLARE cursor_name CURSOR FOR --定义游标                       --SELECT distinct FactoryCode FROM [KhaosReport].[dbo].[T_Khaos_Number_Factory] where DataTime like '%2022-10%'

            SELECT distinct FactoryCode FROM [KhaosReport].[dbo].[T_Khaos_Number_Factory] where DataTime like '%'+@DATADate+'%'              OPEN cursor_name --打开游标         FETCH NEXT FROM cursor_name INTO  @FactoryCodeA--抓取下一行游标数据         WHILE @@FETCH_STATUS = 0             BEGIN

                Declare @FactoryCode    varchar(8)                 Declare @FactoryName    varchar(80)                 Declare @FactoryType    varchar(3)                 Declare @Parent_Factory    varchar(8)                 Declare @Numbers    int                 Declare @ManageNum    int                 Declare @TalnetNum    int                 Declare @TraineeNum    int                 Declare @EpibolyNum    int                 Declare @ShortNum    int                 Declare @UnPositionNum    int                 Declare @NimbleNum    int                 Declare @TemporarilyNum    int                 Declare @CreateTime    datetime                 Declare @DataTime    date                 Declare @ChanJia    int                 Declare @ChanQianJia    int                 Declare @ChangXiu    int                 Declare @DuanXiu    int                 Declare @GongShang    int                 Declare @DaiGang_ChanJianEnd    int                 Declare @Other    int                 Declare @Reserve    varchar(2)                 Declare @Reserve2    varchar(2)                 Declare @Reserve3    varchar(2)                 Declare @Reserve4    varchar(2)                 Declare @Reserve5    varchar(2)                 Declare @Reserve6    varchar(2)                              --把每个列以数值形式增加到表中                 insert into #tempTableA(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 FactoryCode,FactoryName,FactoryType,Parent_Factory,'Numbers' FROM [KhaosReport].[dbo].[T_Khaos_Number_Factory] where FactoryCode=@FactoryCodeA and DataTime like '%'+@DATADate+'%'                 insert into #tempTableA(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 FactoryCode,FactoryName,FactoryType,Parent_Factory,'ManageNum' FROM [KhaosReport].[dbo].[T_Khaos_Number_Factory] where FactoryCode=@FactoryCodeA and DataTime like '%'+@DATADate+'%'                 insert into #tempTableA(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 FactoryCode,FactoryName,FactoryType,Parent_Factory,'TalnetNum' FROM [KhaosReport].[dbo].[T_Khaos_Number_Factory] where FactoryCode=@FactoryCodeA and DataTime like '%'+@DATADate+'%'                 insert into #tempTableA(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 FactoryCode,FactoryName,FactoryType,Parent_Factory,'EpibolyNum' FROM [KhaosReport].[dbo].[T_Khaos_Number_Factory] where FactoryCode=@FactoryCodeA and DataTime like '%'+@DATADate+'%'                 insert into #tempTableA(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 FactoryCode,FactoryName,FactoryType,Parent_Factory,'ShortNum' FROM [KhaosReport].[dbo].[T_Khaos_Number_Factory] where FactoryCode=@FactoryCodeA and DataTime like '%'+@DATADate+'%'                 insert into #tempTableA(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 FactoryCode,FactoryName,FactoryType,Parent_Factory,'UnPositionNum' FROM [KhaosReport].[dbo].[T_Khaos_Number_Factory] where FactoryCode=@FactoryCodeA and DataTime like '%'+@DATADate+'%'                 insert into #tempTableA(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 FactoryCode,FactoryName,FactoryType,Parent_Factory,'NimbleNum' FROM [KhaosReport].[dbo].[T_Khaos_Number_Factory] where FactoryCode=@FactoryCodeA and DataTime like '%'+@DATADate+'%'                 insert into #tempTableA(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 FactoryCode,FactoryName,FactoryType,Parent_Factory,'TemporarilyNum' FROM [KhaosReport].[dbo].[T_Khaos_Number_Factory] where FactoryCode=@FactoryCodeA and DataTime like '%'+@DATADate+'%'                 insert into #tempTableA(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 FactoryCode,FactoryName,FactoryType,Parent_Factory,'ChanJia' FROM [KhaosReport].[dbo].[T_Khaos_Number_Factory] where FactoryCode=@FactoryCodeA and DataTime like '%'+@DATADate+'%'                 insert into #tempTableA(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 FactoryCode,FactoryName,FactoryType,Parent_Factory,'ChanQianJia' FROM [KhaosReport].[dbo].[T_Khaos_Number_Factory] where FactoryCode=@FactoryCodeA and DataTime like '%'+@DATADate+'%'                 insert into #tempTableA(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 FactoryCode,FactoryName,FactoryType,Parent_Factory,'ChangXiu' FROM [KhaosReport].[dbo].[T_Khaos_Number_Factory] where FactoryCode=@FactoryCodeA and DataTime like '%'+@DATADate+'%'                 insert into #tempTableA(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 FactoryCode,FactoryName,FactoryType,Parent_Factory,'DuanXiu' FROM [KhaosReport].[dbo].[T_Khaos_Number_Factory] where FactoryCode=@FactoryCodeA and DataTime like '%'+@DATADate+'%'                 insert into #tempTableA(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 FactoryCode,FactoryName,FactoryType,Parent_Factory,'GongShang' FROM [KhaosReport].[dbo].[T_Khaos_Number_Factory] where FactoryCode=@FactoryCodeA and DataTime like '%'+@DATADate+'%'                 insert into #tempTableA(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 FactoryCode,FactoryName,FactoryType,Parent_Factory,'DaiGang_ChanJianEnd' FROM [KhaosReport].[dbo].[T_Khaos_Number_Factory] where FactoryCode=@FactoryCodeA and DataTime like '%'+@DATADate+'%'                 insert into #tempTableA(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 FactoryCode,FactoryName,FactoryType,Parent_Factory,'Other' FROM [KhaosReport].[dbo].[T_Khaos_Number_Factory] where FactoryCode=@FactoryCodeA and DataTime like '%'+@DATADate+'%'                 insert into #tempTableA(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 FactoryCode,FactoryName,FactoryType,Parent_Factory,'Reserve' FROM [KhaosReport].[dbo].[T_Khaos_Number_Factory] where FactoryCode=@FactoryCodeA and DataTime like '%'+@DATADate+'%'                 insert into #tempTableA(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 FactoryCode,FactoryName,FactoryType,Parent_Factory,'Reserve2' FROM [KhaosReport].[dbo].[T_Khaos_Number_Factory] where FactoryCode=@FactoryCodeA and DataTime like '%'+@DATADate+'%'                 insert into #tempTableA(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 FactoryCode,FactoryName,FactoryType,Parent_Factory,'Reserve3' FROM [KhaosReport].[dbo].[T_Khaos_Number_Factory] where FactoryCode=@FactoryCodeA and DataTime like '%'+@DATADate+'%'                 insert into #tempTableA(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 FactoryCode,FactoryName,FactoryType,Parent_Factory,'Reserve4' FROM [KhaosReport].[dbo].[T_Khaos_Number_Factory] where FactoryCode=@FactoryCodeA and DataTime like '%'+@DATADate+'%'                 insert into #tempTableA(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 FactoryCode,FactoryName,FactoryType,Parent_Factory,'Reserve5' FROM [KhaosReport].[dbo].[T_Khaos_Number_Factory] where FactoryCode=@FactoryCodeA and DataTime like '%'+@DATADate+'%'                 insert into #tempTableA(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 FactoryCode,FactoryName,FactoryType,Parent_Factory,'Reserve6' FROM [KhaosReport].[dbo].[T_Khaos_Number_Factory] where FactoryCode=@FactoryCodeA and DataTime like '%'+@DATADate+'%'                                  --循环单位的当月数据进行处理                 DECLARE cursor_nameA CURSOR FOR --定义游标                                      --SELECT * FROM [KhaosReport].[dbo].[T_Khaos_Number_Factory] where FactoryCode='50089129' and DataTime like '%2022-10%' order by DataTime

                    SELECT FactoryCode,FactoryName,FactoryType,Parent_Factory,Numbers,ManageNum,TalnetNum,TraineeNum,EpibolyNum,ShortNum,UnPositionNum,NimbleNum,TemporarilyNum,CreateTime,DataTime,ChanJia,ChanQianJia,ChangXiu,DuanXiu,GongShang,DaiGang_ChanJianEnd,Other,Reserve,Reserve2,Reserve3,Reserve4,Reserve5,Reserve6 FROM [KhaosReport].[dbo].[T_Khaos_Number_Factory] where FactoryCode=@FactoryCodeA and DataTime like '%'+@DATADate+'%' order by DataTime                      OPEN cursor_nameA --打开游标                 FETCH NEXT FROM cursor_nameA INTO  @FactoryCode,@FactoryName,@FactoryType,@Parent_Factory,@Numbers,@ManageNum,@TalnetNum,@TraineeNum,@EpibolyNum,@ShortNum,@UnPositionNum,@NimbleNum,@TemporarilyNum,@CreateTime,@DataTime,@ChanJia,@ChanQianJia,@ChangXiu,@DuanXiu,@GongShang,@DaiGang_ChanJianEnd,@Other,@Reserve,@Reserve2,@Reserve3,@Reserve4,@Reserve5,@Reserve6--抓取下一行游标数据                 WHILE @@FETCH_STATUS = 0                     BEGIN

                        --拼接日期字段名称                         DECLARE @ColumnDataTime NVARCHAR(100)                         SET @ColumnDataTime ='[' +CONVERT(NVARCHAR(100),@DataTime) + ']' 

                        --给日期字段赋值                         set @Numbers=ISNULL(@Numbers,0)                         EXECUTE('update #tempTableA set ' + @ColumnDataTime + '='+ @Numbers +' where TypeCode=''Numbers'' and FactoryCode='+@FactoryCode )                         set @ManageNum=ISNULL(@ManageNum,0)                         EXECUTE('update #tempTableA set ' + @ColumnDataTime + '='+ @ManageNum +' where TypeCode=''ManageNum'' and FactoryCode='+@FactoryCode )                         set @TalnetNum=ISNULL(@TalnetNum,0)                         EXECUTE('update #tempTableA set ' + @ColumnDataTime + '='+ @TalnetNum +' where TypeCode=''TalnetNum'' and FactoryCode='+@FactoryCode )                         set @TraineeNum=ISNULL(@TraineeNum,0)                         EXECUTE('update #tempTableA set ' + @ColumnDataTime + '='+ @TraineeNum +' where TypeCode=''TraineeNum'' and FactoryCode='+@FactoryCode )                         set @EpibolyNum=ISNULL(@EpibolyNum,0)                         EXECUTE('update #tempTableA set ' + @ColumnDataTime + '='+ @EpibolyNum +' where TypeCode=''EpibolyNum'' and FactoryCode='+@FactoryCode )                         set @ShortNum=ISNULL(@ShortNum,0)                         EXECUTE('update #tempTableA set ' + @ColumnDataTime + '='+ @ShortNum +' where TypeCode=''ShortNum'' and FactoryCode='+@FactoryCode )                         set @UnPositionNum=ISNULL(@UnPositionNum,0)                         EXECUTE('update #tempTableA set ' + @ColumnDataTime + '='+ @UnPositionNum +' where TypeCode=''UnPositionNum'' and FactoryCode='+@FactoryCode )                         set @NimbleNum=ISNULL(@NimbleNum,0)                         EXECUTE('update #tempTableA set ' + @ColumnDataTime + '='+ @NimbleNum +' where TypeCode=''NimbleNum'' and FactoryCode='+@FactoryCode )                         set @TemporarilyNum=ISNULL(@TemporarilyNum,0)                         EXECUTE('update #tempTableA set ' + @ColumnDataTime + '='+ @TemporarilyNum +' where TypeCode=''TemporarilyNum'' and FactoryCode='+@FactoryCode )                         set @ChanJia=ISNULL(@ChanJia,0)                         EXECUTE('update #tempTableA set ' + @ColumnDataTime + '='+ @ChanJia +' where TypeCode=''ChanJia'' and FactoryCode='+@FactoryCode )                         set @ChanQianJia=ISNULL(@ChanQianJia,0)                         EXECUTE('update #tempTableA set ' + @ColumnDataTime + '='+ @ChanQianJia +' where TypeCode=''ChanQianJia'' and FactoryCode='+@FactoryCode )                         set @ChangXiu=ISNULL(@ChangXiu,0)                         EXECUTE('update #tempTableA set ' + @ColumnDataTime + '='+ @ChangXiu +' where TypeCode=''ChangXiu'' and FactoryCode='+@FactoryCode )                         set @DuanXiu=ISNULL(@DuanXiu,0)                         EXECUTE('update #tempTableA set ' + @ColumnDataTime + '='+ @DuanXiu +' where TypeCode=''DuanXiu'' and FactoryCode='+@FactoryCode )                         set @GongShang=ISNULL(@GongShang,0)                         EXECUTE('update #tempTableA set ' + @ColumnDataTime + '='+ @GongShang +' where TypeCode=''GongShang'' and FactoryCode='+@FactoryCode )                         set @DaiGang_ChanJianEnd=ISNULL(@DaiGang_ChanJianEnd,0)                         EXECUTE('update #tempTableA set ' + @ColumnDataTime + '='+ @DaiGang_ChanJianEnd +' where TypeCode=''DaiGang_ChanJianEnd'' and FactoryCode='+@FactoryCode )                         set @Other=ISNULL(@Other,0)                         EXECUTE('update #tempTableA set ' + @ColumnDataTime + '='+ @Other +' where TypeCode=''Other'' and FactoryCode='+@FactoryCode )                         set @Reserve=ISNULL(@Reserve,0)                         EXECUTE('update #tempTableA set ' + @ColumnDataTime + '='+ @Reserve +' where TypeCode=''Reserve'' and FactoryCode='+@FactoryCode )                         set @Reserve2=ISNULL(@Reserve2,0)                         EXECUTE('update #tempTableA set ' + @ColumnDataTime + '='+ @Reserve2 +' where TypeCode=''Reserve2'' and FactoryCode='+@FactoryCode )                         set @Reserve3=ISNULL(@Reserve3,0)                         EXECUTE('update #tempTableA set ' + @ColumnDataTime + '='+ @Reserve3 +' where TypeCode=''Reserve3'' and FactoryCode='+@FactoryCode )                         set @Reserve4=ISNULL(@Reserve4,0)                         EXECUTE('update #tempTableA set ' + @ColumnDataTime + '='+ @Reserve4 +' where TypeCode=''Reserve4'' and FactoryCode='+@FactoryCode )                         set @Reserve5=ISNULL(@Reserve5,0)                         EXECUTE('update #tempTableA set ' + @ColumnDataTime + '='+ @Reserve5 +' where TypeCode=''Reserve5'' and FactoryCode='+@FactoryCode )                         set @Reserve6=ISNULL(@Reserve6,0)                         EXECUTE('update #tempTableA set ' + @ColumnDataTime + '='+ @Reserve6 +' where TypeCode=''Reserve6'' and FactoryCode='+@FactoryCode )

                        FETCH NEXT FROM cursor_nameA INTO @FactoryCode,@FactoryName,@FactoryType,@Parent_Factory,@Numbers,@ManageNum,@TalnetNum,@TraineeNum,@EpibolyNum,@ShortNum,@UnPositionNum,@NimbleNum,@TemporarilyNum,@CreateTime,@DataTime,@ChanJia,@ChanQianJia,@ChangXiu,@DuanXiu,@GongShang,@DaiGang_ChanJianEnd,@Other,@Reserve,@Reserve2,@Reserve3,@Reserve4,@Reserve5,@Reserve6                     END                 CLOSE cursor_nameA --关闭游标                 DEALLOCATE cursor_nameA --释放游标

                FETCH NEXT FROM cursor_name INTO @FactoryCodeA             END         CLOSE cursor_name --关闭游标         DEALLOCATE cursor_name --释放游标

    --==============================================数据存储操作  End=============================================================

    --==============================================上一级数据存储操作 Start======================================================                  --通过工厂获得指定月份数据             Declare @Parent_FactoryA varchar(8)

        --获得当前月份的工厂,循环单位         DECLARE cursor_nameParent CURSOR FOR --定义游标                  select distinct Parent_Factory from #tempTableA              OPEN cursor_nameParent --打开游标         FETCH NEXT FROM cursor_nameParent INTO  @Parent_FactoryA--抓取下一行游标数据         WHILE @@FETCH_STATUS = 0             BEGIN

                --把每个列以数值形式增加到表中                 insert into #tempTableB(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 org_code,org_name,org_type,parent_code,'Numbers' FROM [KhaosReport].[dbo].[t_khaos_fac_subordinate_relation] where org_code=@Parent_FactoryA                 insert into #tempTableB(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 org_code,org_name,org_type,parent_code,'ManageNum' FROM [KhaosReport].[dbo].[t_khaos_fac_subordinate_relation] where org_code=@Parent_FactoryA                 insert into #tempTableB(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 org_code,org_name,org_type,parent_code,'TalnetNum' FROM [KhaosReport].[dbo].[t_khaos_fac_subordinate_relation] where org_code=@Parent_FactoryA                 insert into #tempTableB(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 org_code,org_name,org_type,parent_code,'EpibolyNum' FROM [KhaosReport].[dbo].[t_khaos_fac_subordinate_relation] where org_code=@Parent_FactoryA                 insert into #tempTableB(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 org_code,org_name,org_type,parent_code,'ShortNum' FROM [KhaosReport].[dbo].[t_khaos_fac_subordinate_relation] where org_code=@Parent_FactoryA                 insert into #tempTableB(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 org_code,org_name,org_type,parent_code,'UnPositionNum' FROM [KhaosReport].[dbo].[t_khaos_fac_subordinate_relation] where org_code=@Parent_FactoryA                 insert into #tempTableB(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 org_code,org_name,org_type,parent_code,'NimbleNum' FROM [KhaosReport].[dbo].[t_khaos_fac_subordinate_relation] where org_code=@Parent_FactoryA                 insert into #tempTableB(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 org_code,org_name,org_type,parent_code,'TemporarilyNum' FROM [KhaosReport].[dbo].[t_khaos_fac_subordinate_relation] where org_code=@Parent_FactoryA                 insert into #tempTableB(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 org_code,org_name,org_type,parent_code,'ChanJia' FROM [KhaosReport].[dbo].[t_khaos_fac_subordinate_relation] where org_code=@Parent_FactoryA                 insert into #tempTableB(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 org_code,org_name,org_type,parent_code,'ChanQianJia' FROM [KhaosReport].[dbo].[t_khaos_fac_subordinate_relation] where org_code=@Parent_FactoryA                 insert into #tempTableB(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 org_code,org_name,org_type,parent_code,'ChangXiu' FROM [KhaosReport].[dbo].[t_khaos_fac_subordinate_relation] where org_code=@Parent_FactoryA                 insert into #tempTableB(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 org_code,org_name,org_type,parent_code,'DuanXiu' FROM [KhaosReport].[dbo].[t_khaos_fac_subordinate_relation] where org_code=@Parent_FactoryA                 insert into #tempTableB(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 org_code,org_name,org_type,parent_code,'GongShang' FROM [KhaosReport].[dbo].[t_khaos_fac_subordinate_relation] where org_code=@Parent_FactoryA                 insert into #tempTableB(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 org_code,org_name,org_type,parent_code,'DaiGang_ChanJianEnd' FROM [KhaosReport].[dbo].[t_khaos_fac_subordinate_relation] where org_code=@Parent_FactoryA                 insert into #tempTableB(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 org_code,org_name,org_type,parent_code,'Other' FROM [KhaosReport].[dbo].[t_khaos_fac_subordinate_relation] where org_code=@Parent_FactoryA                 insert into #tempTableB(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 org_code,org_name,org_type,parent_code,'Reserve' FROM [KhaosReport].[dbo].[t_khaos_fac_subordinate_relation] where org_code=@Parent_FactoryA                 insert into #tempTableB(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 org_code,org_name,org_type,parent_code,'Reserve2' FROM [KhaosReport].[dbo].[t_khaos_fac_subordinate_relation] where org_code=@Parent_FactoryA                 insert into #tempTableB(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 org_code,org_name,org_type,parent_code,'Reserve3' FROM [KhaosReport].[dbo].[t_khaos_fac_subordinate_relation] where org_code=@Parent_FactoryA                 insert into #tempTableB(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 org_code,org_name,org_type,parent_code,'Reserve4' FROM [KhaosReport].[dbo].[t_khaos_fac_subordinate_relation] where org_code=@Parent_FactoryA                 insert into #tempTableB(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 org_code,org_name,org_type,parent_code,'Reserve5' FROM [KhaosReport].[dbo].[t_khaos_fac_subordinate_relation] where org_code=@Parent_FactoryA                 insert into #tempTableB(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 org_code,org_name,org_type,parent_code,'Reserve6' FROM [KhaosReport].[dbo].[t_khaos_fac_subordinate_relation] where org_code=@Parent_FactoryA

                                 --通过工厂获得指定月份数据                     Declare @StrsDate varchar(12)

                --获得当前月份的工厂,循环单位                 DECLARE cursor_nameParentA CURSOR FOR --定义游标                          SELECT StrsDate FROM #tempTableDate                      OPEN cursor_nameParentA --打开游标                 FETCH NEXT FROM cursor_nameParentA INTO  @StrsDate--抓取下一行游标数据                 WHILE @@FETCH_STATUS = 0                     BEGIN

                        --给日期字段赋值                         --update #tempTableB set @StrsDate=(select sum(CAST( ISNULL(@StrsDate,0)as int)) from #tempTableA where Parent_Factory=@Parent_FactoryA and TypeCode='Numbers') where FactoryCode=@Parent_FactoryA and TypeCode='Numbers'                                                  EXECUTE('update #tempTableB set ' + @StrsDate + '=(select sum(CAST( ISNULL('+ @StrsDate +',0)as int)) from #tempTableA where Parent_Factory='+@Parent_FactoryA+' and TypeCode=''Numbers'') where TypeCode=''Numbers'' and FactoryCode='+@Parent_FactoryA )                         EXECUTE('update #tempTableB set ' + @StrsDate + '=(select sum(CAST( ISNULL('+ @StrsDate +',0)as int)) from #tempTableA where Parent_Factory='+@Parent_FactoryA+' and TypeCode=''ManageNum'') where TypeCode=''ManageNum'' and FactoryCode='+@Parent_FactoryA )                         EXECUTE('update #tempTableB set ' + @StrsDate + '=(select sum(CAST( ISNULL('+ @StrsDate +',0)as int)) from #tempTableA where Parent_Factory='+@Parent_FactoryA+' and TypeCode=''TalnetNum'') where TypeCode=''TalnetNum'' and FactoryCode='+@Parent_FactoryA )                         EXECUTE('update #tempTableB set ' + @StrsDate + '=(select sum(CAST( ISNULL('+ @StrsDate +',0)as int)) from #tempTableA where Parent_Factory='+@Parent_FactoryA+' and TypeCode=''EpibolyNum'') where TypeCode=''EpibolyNum'' and FactoryCode='+@Parent_FactoryA )                         EXECUTE('update #tempTableB set ' + @StrsDate + '=(select sum(CAST( ISNULL('+ @StrsDate +',0)as int)) from #tempTableA where Parent_Factory='+@Parent_FactoryA+' and TypeCode=''ShortNum'') where TypeCode=''ShortNum'' and FactoryCode='+@Parent_FactoryA )                         EXECUTE('update #tempTableB set ' + @StrsDate + '=(select sum(CAST( ISNULL('+ @StrsDate +',0)as int)) from #tempTableA where Parent_Factory='+@Parent_FactoryA+' and TypeCode=''UnPositionNum'') where TypeCode=''UnPositionNum'' and FactoryCode='+@Parent_FactoryA )                         EXECUTE('update #tempTableB set ' + @StrsDate + '=(select sum(CAST( ISNULL('+ @StrsDate +',0)as int)) from #tempTableA where Parent_Factory='+@Parent_FactoryA+' and TypeCode=''NimbleNum'') where TypeCode=''NimbleNum'' and FactoryCode='+@Parent_FactoryA )                         EXECUTE('update #tempTableB set ' + @StrsDate + '=(select sum(CAST( ISNULL('+ @StrsDate +',0)as int)) from #tempTableA where Parent_Factory='+@Parent_FactoryA+' and TypeCode=''TemporarilyNum'') where TypeCode=''TemporarilyNum'' and FactoryCode='+@Parent_FactoryA )                         EXECUTE('update #tempTableB set ' + @StrsDate + '=(select sum(CAST( ISNULL('+ @StrsDate +',0)as int)) from #tempTableA where Parent_Factory='+@Parent_FactoryA+' and TypeCode=''ChanJia'') where TypeCode=''ChanJia'' and FactoryCode='+@Parent_FactoryA )                         EXECUTE('update #tempTableB set ' + @StrsDate + '=(select sum(CAST( ISNULL('+ @StrsDate +',0)as int)) from #tempTableA where Parent_Factory='+@Parent_FactoryA+' and TypeCode=''ChanQianJia'') where TypeCode=''ChanQianJia'' and FactoryCode='+@Parent_FactoryA )                         EXECUTE('update #tempTableB set ' + @StrsDate + '=(select sum(CAST( ISNULL('+ @StrsDate +',0)as int)) from #tempTableA where Parent_Factory='+@Parent_FactoryA+' and TypeCode=''ChangXiu'') where TypeCode=''ChangXiu'' and FactoryCode='+@Parent_FactoryA )                         EXECUTE('update #tempTableB set ' + @StrsDate + '=(select sum(CAST( ISNULL('+ @StrsDate +',0)as int)) from #tempTableA where Parent_Factory='+@Parent_FactoryA+' and TypeCode=''DuanXiu'') where TypeCode=''DuanXiu'' and FactoryCode='+@Parent_FactoryA )                         EXECUTE('update #tempTableB set ' + @StrsDate + '=(select sum(CAST( ISNULL('+ @StrsDate +',0)as int)) from #tempTableA where Parent_Factory='+@Parent_FactoryA+' and TypeCode=''GongShang'') where TypeCode=''GongShang'' and FactoryCode='+@Parent_FactoryA )                         EXECUTE('update #tempTableB set ' + @StrsDate + '=(select sum(CAST( ISNULL('+ @StrsDate +',0)as int)) from #tempTableA where Parent_Factory='+@Parent_FactoryA+' and TypeCode=''DaiGang_ChanJianEnd'') where TypeCode=''DaiGang_ChanJianEnd'' and FactoryCode='+@Parent_FactoryA )                         EXECUTE('update #tempTableB set ' + @StrsDate + '=(select sum(CAST( ISNULL('+ @StrsDate +',0)as int)) from #tempTableA where Parent_Factory='+@Parent_FactoryA+' and TypeCode=''Other'') where TypeCode=''Other'' and FactoryCode='+@Parent_FactoryA )                         EXECUTE('update #tempTableB set ' + @StrsDate + '=(select sum(CAST( ISNULL('+ @StrsDate +',0)as int)) from #tempTableA where Parent_Factory='+@Parent_FactoryA+' and TypeCode=''Reserve'') where TypeCode=''Reserve'' and FactoryCode='+@Parent_FactoryA )                         EXECUTE('update #tempTableB set ' + @StrsDate + '=(select sum(CAST( ISNULL('+ @StrsDate +',0)as int)) from #tempTableA where Parent_Factory='+@Parent_FactoryA+' and TypeCode=''Reserve2'') where TypeCode=''Reserve2'' and FactoryCode='+@Parent_FactoryA )                         EXECUTE('update #tempTableB set ' + @StrsDate + '=(select sum(CAST( ISNULL('+ @StrsDate +',0)as int)) from #tempTableA where Parent_Factory='+@Parent_FactoryA+' and TypeCode=''Reserve3'') where TypeCode=''Reserve3'' and FactoryCode='+@Parent_FactoryA )                         EXECUTE('update #tempTableB set ' + @StrsDate + '=(select sum(CAST( ISNULL('+ @StrsDate +',0)as int)) from #tempTableA where Parent_Factory='+@Parent_FactoryA+' and TypeCode=''Reserve4'') where TypeCode=''Reserve4'' and FactoryCode='+@Parent_FactoryA )                         EXECUTE('update #tempTableB set ' + @StrsDate + '=(select sum(CAST( ISNULL('+ @StrsDate +',0)as int)) from #tempTableA where Parent_Factory='+@Parent_FactoryA+' and TypeCode=''Reserve5'') where TypeCode=''Reserve5'' and FactoryCode='+@Parent_FactoryA )                         EXECUTE('update #tempTableB set ' + @StrsDate + '=(select sum(CAST( ISNULL('+ @StrsDate +',0)as int)) from #tempTableA where Parent_Factory='+@Parent_FactoryA+' and TypeCode=''Reserve6'') where TypeCode=''Reserve6'' and FactoryCode='+@Parent_FactoryA )

                        FETCH NEXT FROM cursor_nameParentA INTO @StrsDate                     END                 CLOSE cursor_nameParentA --关闭游标                 DEALLOCATE cursor_nameParentA --释放游标

                FETCH NEXT FROM cursor_nameParent INTO @Parent_FactoryA             END         CLOSE cursor_nameParent --关闭游标         DEALLOCATE cursor_nameParent --释放游标

    --==============================================上一级数据存储操作  End=======================================================

    --==============================================顶级数据存储操作 Start======================================================

        --通过工厂获得指定月份数据             Declare @Parent_FactoryTop varchar(8)

        --获得当前月份的工厂,循环单位         DECLARE cursor_nameParentTop CURSOR FOR --定义游标                  select distinct Parent_Factory from #tempTableB              OPEN cursor_nameParentTop --打开游标         FETCH NEXT FROM cursor_nameParentTop INTO  @Parent_FactoryTop--抓取下一行游标数据         WHILE @@FETCH_STATUS = 0             BEGIN                              --把每个列以数值形式增加到表中                 insert into #tempTableC(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 org_code,org_name,org_type,parent_code,'Numbers' FROM [KhaosReport].[dbo].[t_khaos_fac_subordinate_relation] where org_code=@Parent_FactoryTop                 insert into #tempTableC(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 org_code,org_name,org_type,parent_code,'ManageNum' FROM [KhaosReport].[dbo].[t_khaos_fac_subordinate_relation] where org_code=@Parent_FactoryTop                 insert into #tempTableC(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 org_code,org_name,org_type,parent_code,'TalnetNum' FROM [KhaosReport].[dbo].[t_khaos_fac_subordinate_relation] where org_code=@Parent_FactoryTop                 insert into #tempTableC(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 org_code,org_name,org_type,parent_code,'EpibolyNum' FROM [KhaosReport].[dbo].[t_khaos_fac_subordinate_relation] where org_code=@Parent_FactoryTop                 insert into #tempTableC(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 org_code,org_name,org_type,parent_code,'ShortNum' FROM [KhaosReport].[dbo].[t_khaos_fac_subordinate_relation] where org_code=@Parent_FactoryTop                 insert into #tempTableC(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 org_code,org_name,org_type,parent_code,'UnPositionNum' FROM [KhaosReport].[dbo].[t_khaos_fac_subordinate_relation] where org_code=@Parent_FactoryTop                 insert into #tempTableC(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 org_code,org_name,org_type,parent_code,'NimbleNum' FROM [KhaosReport].[dbo].[t_khaos_fac_subordinate_relation] where org_code=@Parent_FactoryTop                 insert into #tempTableC(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 org_code,org_name,org_type,parent_code,'TemporarilyNum' FROM [KhaosReport].[dbo].[t_khaos_fac_subordinate_relation] where org_code=@Parent_FactoryTop                 insert into #tempTableC(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 org_code,org_name,org_type,parent_code,'ChanJia' FROM [KhaosReport].[dbo].[t_khaos_fac_subordinate_relation] where org_code=@Parent_FactoryTop                 insert into #tempTableC(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 org_code,org_name,org_type,parent_code,'ChanQianJia' FROM [KhaosReport].[dbo].[t_khaos_fac_subordinate_relation] where org_code=@Parent_FactoryTop                 insert into #tempTableC(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 org_code,org_name,org_type,parent_code,'ChangXiu' FROM [KhaosReport].[dbo].[t_khaos_fac_subordinate_relation] where org_code=@Parent_FactoryTop                 insert into #tempTableC(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 org_code,org_name,org_type,parent_code,'DuanXiu' FROM [KhaosReport].[dbo].[t_khaos_fac_subordinate_relation] where org_code=@Parent_FactoryTop                 insert into #tempTableC(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 org_code,org_name,org_type,parent_code,'GongShang' FROM [KhaosReport].[dbo].[t_khaos_fac_subordinate_relation] where org_code=@Parent_FactoryTop                 insert into #tempTableC(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 org_code,org_name,org_type,parent_code,'DaiGang_ChanJianEnd' FROM [KhaosReport].[dbo].[t_khaos_fac_subordinate_relation] where org_code=@Parent_FactoryTop                 insert into #tempTableC(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 org_code,org_name,org_type,parent_code,'Other' FROM [KhaosReport].[dbo].[t_khaos_fac_subordinate_relation] where org_code=@Parent_FactoryTop                 insert into #tempTableC(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 org_code,org_name,org_type,parent_code,'Reserve' FROM [KhaosReport].[dbo].[t_khaos_fac_subordinate_relation] where org_code=@Parent_FactoryTop                 insert into #tempTableC(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 org_code,org_name,org_type,parent_code,'Reserve2' FROM [KhaosReport].[dbo].[t_khaos_fac_subordinate_relation] where org_code=@Parent_FactoryTop                 insert into #tempTableC(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 org_code,org_name,org_type,parent_code,'Reserve3' FROM [KhaosReport].[dbo].[t_khaos_fac_subordinate_relation] where org_code=@Parent_FactoryTop                 insert into #tempTableC(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 org_code,org_name,org_type,parent_code,'Reserve4' FROM [KhaosReport].[dbo].[t_khaos_fac_subordinate_relation] where org_code=@Parent_FactoryTop                 insert into #tempTableC(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 org_code,org_name,org_type,parent_code,'Reserve5' FROM [KhaosReport].[dbo].[t_khaos_fac_subordinate_relation] where org_code=@Parent_FactoryTop                 insert into #tempTableC(FactoryCode,FactoryName,FactoryType,Parent_Factory,TypeCode)                 SELECT top 1 org_code,org_name,org_type,parent_code,'Reserve6' FROM [KhaosReport].[dbo].[t_khaos_fac_subordinate_relation] where org_code=@Parent_FactoryTop                                  --通过工厂获得指定月份数据                     Declare @StrsDateTop varchar(12)

                --获得当前月份的工厂,循环单位                 DECLARE cursor_nameParentTopA CURSOR FOR --定义游标                          SELECT StrsDate FROM #tempTableDate                      OPEN cursor_nameParentTopA --打开游标                 FETCH NEXT FROM cursor_nameParentTopA INTO  @StrsDateTop--抓取下一行游标数据                 WHILE @@FETCH_STATUS = 0                     BEGIN

                        --给日期字段赋值                         --update #tempTableB set @StrsDate=(select sum(CAST( ISNULL(@StrsDate,0)as int)) from #tempTableA where Parent_Factory=@Parent_FactoryA and TypeCode='Numbers') where FactoryCode=@Parent_FactoryA and TypeCode='Numbers'                                                  EXECUTE('update #tempTableC set ' + @StrsDateTop + '=(select sum(CAST( ISNULL('+ @StrsDateTop +',0)as int)) from #tempTableB where Parent_Factory='+@Parent_FactoryTop+' and TypeCode=''Numbers'') where TypeCode=''Numbers'' and FactoryCode='+@Parent_FactoryTop )                         EXECUTE('update #tempTableC set ' + @StrsDateTop + '=(select sum(CAST( ISNULL('+ @StrsDateTop +',0)as int)) from #tempTableB where Parent_Factory='+@Parent_FactoryTop+' and TypeCode=''ManageNum'') where TypeCode=''ManageNum'' and FactoryCode='+@Parent_FactoryTop )                         EXECUTE('update #tempTableC set ' + @StrsDateTop + '=(select sum(CAST( ISNULL('+ @StrsDateTop +',0)as int)) from #tempTableB where Parent_Factory='+@Parent_FactoryTop+' and TypeCode=''TalnetNum'') where TypeCode=''TalnetNum'' and FactoryCode='+@Parent_FactoryTop )                         EXECUTE('update #tempTableC set ' + @StrsDateTop + '=(select sum(CAST( ISNULL('+ @StrsDateTop +',0)as int)) from #tempTableB where Parent_Factory='+@Parent_FactoryTop+' and TypeCode=''EpibolyNum'') where TypeCode=''EpibolyNum'' and FactoryCode='+@Parent_FactoryTop )                         EXECUTE('update #tempTableC set ' + @StrsDateTop + '=(select sum(CAST( ISNULL('+ @StrsDateTop +',0)as int)) from #tempTableB where Parent_Factory='+@Parent_FactoryTop+' and TypeCode=''ShortNum'') where TypeCode=''ShortNum'' and FactoryCode='+@Parent_FactoryTop )                         EXECUTE('update #tempTableC set ' + @StrsDateTop + '=(select sum(CAST( ISNULL('+ @StrsDateTop +',0)as int)) from #tempTableB where Parent_Factory='+@Parent_FactoryTop+' and TypeCode=''UnPositionNum'') where TypeCode=''UnPositionNum'' and FactoryCode='+@Parent_FactoryTop )                         EXECUTE('update #tempTableC set ' + @StrsDateTop + '=(select sum(CAST( ISNULL('+ @StrsDateTop +',0)as int)) from #tempTableB where Parent_Factory='+@Parent_FactoryTop+' and TypeCode=''NimbleNum'') where TypeCode=''NimbleNum'' and FactoryCode='+@Parent_FactoryTop )                         EXECUTE('update #tempTableC set ' + @StrsDateTop + '=(select sum(CAST( ISNULL('+ @StrsDateTop +',0)as int)) from #tempTableB where Parent_Factory='+@Parent_FactoryTop+' and TypeCode=''TemporarilyNum'') where TypeCode=''TemporarilyNum'' and FactoryCode='+@Parent_FactoryTop )                         EXECUTE('update #tempTableC set ' + @StrsDateTop + '=(select sum(CAST( ISNULL('+ @StrsDateTop +',0)as int)) from #tempTableB where Parent_Factory='+@Parent_FactoryTop+' and TypeCode=''ChanJia'') where TypeCode=''ChanJia'' and FactoryCode='+@Parent_FactoryTop )                         EXECUTE('update #tempTableC set ' + @StrsDateTop + '=(select sum(CAST( ISNULL('+ @StrsDateTop +',0)as int)) from #tempTableB where Parent_Factory='+@Parent_FactoryTop+' and TypeCode=''ChanQianJia'') where TypeCode=''ChanQianJia'' and FactoryCode='+@Parent_FactoryTop )                         EXECUTE('update #tempTableC set ' + @StrsDateTop + '=(select sum(CAST( ISNULL('+ @StrsDateTop +',0)as int)) from #tempTableB where Parent_Factory='+@Parent_FactoryTop+' and TypeCode=''ChangXiu'') where TypeCode=''ChangXiu'' and FactoryCode='+@Parent_FactoryTop )                         EXECUTE('update #tempTableC set ' + @StrsDateTop + '=(select sum(CAST( ISNULL('+ @StrsDateTop +',0)as int)) from #tempTableB where Parent_Factory='+@Parent_FactoryTop+' and TypeCode=''DuanXiu'') where TypeCode=''DuanXiu'' and FactoryCode='+@Parent_FactoryTop )                         EXECUTE('update #tempTableC set ' + @StrsDateTop + '=(select sum(CAST( ISNULL('+ @StrsDateTop +',0)as int)) from #tempTableB where Parent_Factory='+@Parent_FactoryTop+' and TypeCode=''GongShang'') where TypeCode=''GongShang'' and FactoryCode='+@Parent_FactoryTop )                         EXECUTE('update #tempTableC set ' + @StrsDateTop + '=(select sum(CAST( ISNULL('+ @StrsDateTop +',0)as int)) from #tempTableB where Parent_Factory='+@Parent_FactoryTop+' and TypeCode=''DaiGang_ChanJianEnd'') where TypeCode=''DaiGang_ChanJianEnd'' and FactoryCode='+@Parent_FactoryTop )                         EXECUTE('update #tempTableC set ' + @StrsDateTop + '=(select sum(CAST( ISNULL('+ @StrsDateTop +',0)as int)) from #tempTableB where Parent_Factory='+@Parent_FactoryTop+' and TypeCode=''Other'') where TypeCode=''Other'' and FactoryCode='+@Parent_FactoryTop )                         EXECUTE('update #tempTableC set ' + @StrsDateTop + '=(select sum(CAST( ISNULL('+ @StrsDateTop +',0)as int)) from #tempTableB where Parent_Factory='+@Parent_FactoryTop+' and TypeCode=''Reserve'') where TypeCode=''Reserve'' and FactoryCode='+@Parent_FactoryTop )                         EXECUTE('update #tempTableC set ' + @StrsDateTop + '=(select sum(CAST( ISNULL('+ @StrsDateTop +',0)as int)) from #tempTableB where Parent_Factory='+@Parent_FactoryTop+' and TypeCode=''Reserve2'') where TypeCode=''Reserve2'' and FactoryCode='+@Parent_FactoryTop )                         EXECUTE('update #tempTableC set ' + @StrsDateTop + '=(select sum(CAST( ISNULL('+ @StrsDateTop +',0)as int)) from #tempTableB where Parent_Factory='+@Parent_FactoryTop+' and TypeCode=''Reserve3'') where TypeCode=''Reserve3'' and FactoryCode='+@Parent_FactoryTop )                         EXECUTE('update #tempTableC set ' + @StrsDateTop + '=(select sum(CAST( ISNULL('+ @StrsDateTop +',0)as int)) from #tempTableB where Parent_Factory='+@Parent_FactoryTop+' and TypeCode=''Reserve4'') where TypeCode=''Reserve4'' and FactoryCode='+@Parent_FactoryTop )                         EXECUTE('update #tempTableC set ' + @StrsDateTop + '=(select sum(CAST( ISNULL('+ @StrsDateTop +',0)as int)) from #tempTableB where Parent_Factory='+@Parent_FactoryTop+' and TypeCode=''Reserve5'') where TypeCode=''Reserve5'' and FactoryCode='+@Parent_FactoryTop )                         EXECUTE('update #tempTableC set ' + @StrsDateTop + '=(select sum(CAST( ISNULL('+ @StrsDateTop +',0)as int)) from #tempTableB where Parent_Factory='+@Parent_FactoryTop+' and TypeCode=''Reserve6'') where TypeCode=''Reserve6'' and FactoryCode='+@Parent_FactoryTop )

                        FETCH NEXT FROM cursor_nameParentTopA INTO @StrsDateTop                     END                 CLOSE cursor_nameParentTopA --关闭游标                 DEALLOCATE cursor_nameParentTopA --释放游标                              FETCH NEXT FROM cursor_nameParentTop INTO @Parent_FactoryTop             END         CLOSE cursor_nameParentTop --关闭游标         DEALLOCATE cursor_nameParentTop --释放游标

    --==============================================顶级数据存储操作  End=======================================================                  end          --select * from #tempTableA     --select * from #tempTableB

    --select * from #tempTableC          --==============================================按级合并数据  Start=======================================================          --通过工厂获得指定月份数据         Declare @Parent_FactorySummary varchar(8)

    --获得当前月份的工厂,循环单位     DECLARE cursor_nameParentSummary CURSOR FOR --定义游标              select distinct FactoryCode from #tempTableB order by FactoryCode          OPEN cursor_nameParentSummary --打开游标     FETCH NEXT FROM cursor_nameParentSummary INTO  @Parent_FactorySummary--抓取下一行游标数据     WHILE @@FETCH_STATUS = 0         BEGIN                          insert into #tempTableC             select * from #tempTableB where FactoryCode=@Parent_FactorySummary                          insert into #tempTableC             select * from #tempTableA where Parent_Factory=@Parent_FactorySummary order by FactoryCode

                         FETCH NEXT FROM cursor_nameParentSummary INTO @Parent_FactorySummary         END     CLOSE cursor_nameParentSummary --关闭游标     DEALLOCATE cursor_nameParentSummary --释放游标

         --==============================================按级合并数据  End=======================================================     --获取最后数据     select * from #tempTableC order by FactoryType,FactoryCode

    --工厂的去重集合     select distinct FactoryCode,FactoryName,FactoryType,Parent_Factory from #tempTableC order by FactoryType,FactoryCode               select * from [dbo].[T_Khaos_Number_Factory] where DataTime like '%'+@DATADate+'%'

END

GO