CREATETABLETempdb..[PXtbl_GZB697414260](cGZGradeNumnvarchar(3),cPsn_Numnvarchar(20),cDept_Numnvarchar(255),iMonthINTEGER,C_0nvarchar(255),C_1nvarchar(255),C_2[numeric](18,6),C_3[numeric](18,6),C_4[numeric](18,6),C_5[numeric](18,6),C_6[numeric](18,6),C_7[numeric](18,6),C_8[numeric](18,6),C_9[numeric](18,6),C_10[numeric](18,6),C_11[numeric](18,6),C_12[numeric](18,6),C_13[numeric](18,6),C_14[numeric](18,6),C_15[numeric](18,6),C_16[numeric](18,6),C_17[numeric](18,6),C_18[numeric](18,6),C_19[numeric](18,6),C_20[numeric](18,6),C_21[numeric](18,6),C_22[numeric](18,6),C_23[numeric](18,6),C_24[numeric](18,6),C_25[numeric](18,6),C_26[numeric](18,6),C_27[numeric](18,6),C_28[numeric](18,6),C_29[numeric](18,6),C_30[numeric](18,6),C_31[numeric](18,6),C_32nvarchar(255))INSERTINTOTempdb..[PXtbl_GZB697414260](cGZGradeNum,cPsn_Num,cDept_Num,iMonth,C_0,C_1,C_2,C_3,C_4,C_5,C_6,C_7,C_8,C_9,C_10,C_11,C_12,C_13,C_14,C_15,C_16,C_17,C_18,C_19,C_20,C_21,C_22,C_23,C_24,C_25,C_26,C_27,C_28,C_29,C_30,C_31,C_32)SELECTWA_GZData.cGZGradeNum,WA_GZData.cPsn_Num,WA_GZData.cDept_Num,WA_GZData.iMonth,WA_GZData.cPsn_Num,WA_GZData.cPsn_Name,F_1,F_2,F_3,F_4,F_5,F_6,F_7,F_1000,F_1001,F_1002,F_1005,F_1003,F_1004,F_1006,F_8,F_9,F_10,F_11,F_12,F_13,F_14,F_15,F_16,F_17,F_18,F_19,F_20,F_21,F_22,F_23,F_24FROM((WA_GZDataINNERJOIN(WA_psnleftjoinaa_bankonaa_bank.i_id=wa_psn.i_id)ONWA_GZData.cGZGradeNum=WA_Psn.cGZGradeNumANDWA_GZData.cPsn_Num=WA_psn.cPsn_NumANDWA_GZData.cPsn_Name=WA_Psn.cPsn_Name)INNERJOINDepartmentONDepartment.cDepCode=WA_GZData.cDept_Num)INNERJOINWA_gradeONWA_grade.iPsnGrd_id=WA_GZData.iPsnGrd_idWHEREWA_GZData.cGZGradeNum=N'004'ANDWA_GZData.bTFBZ=0ANDWA_GZData.bDCBZ=0orderbyWA_GZData.cDept_Num,WA_GZData.cPsn_NumSELECTC_0,C_1,C_2,C_3,C_4,C_5,C_6,C_7,C_8,C_9,C_10,C_11,C_12,C_13,C_14,C_15,C_16,C_17,C_18,C_19,C_20,C_21,C_22,C_23,C_24,C_25,C_26,C_27,C_28,C_29,C_30,C_31,C_32FROMTempdb..[PXtbl_GZB697414260]WHEREiMonth=3ANDcDept_NumIN(SELECTcDepCodeFROMDepartmentWHEREcDepCodelike'0%')
