文档介绍:CREATE PROC p_yearReport
--²ÎÊý
***@year varchar(4),
***@sitetype varchar(50)
AS
--´´½¨ÁÙʱ±í
CREATE TABLE #BaseTemp
(
id int,
areaname varchar(50),
htzs int,
htzmj int,
htzje float,
m1_f float,
m1_fz as isnull(m1_f,0),
m1_d float,
m1_dz as isnull(m1_d,0),
m2_f float,
m2_fz as isnull(m1_f,0)+isnull(m2_f,0),
m2_d float,
m2_dz as isnull(m1_d,0)+isnull(m2_d,0),
m3_f float,
m3_fz as isnull(m1_f,0)+ isnull(m2_f,0)+isnull(m3_f,0),
m3_d float,
m3_dz as isnull(m1_d,0)+isnull(m2_d,0)+isnull(m3_d,0),
m4_f float,
m4_fz as isnull(m1_f,0)+ isnull(m2_f,0)+isnull(m3_f,0)+isnull(m4_f,0),
m4_d float,
m4_dz as isnull(m1_d,0)+isnull(m2_d,0)+isnull(m3_d,0)+isnull(m4_d,0),
m5_f float,
m5_fz as isnull(m1_f,0)+ isnull(m2_f,0)+isnull(m3_f,0)+isnull(m4_f,0)+isnull(m5_f,0),
m5_d float,
m5_dz as isnull(m1_d,0)+isnull(m2_d,0)+isnull(m3_d,0)+isnull(m4_d,0)+isnull(m5_d,0),
m6_f float,
m6_fz as isnull(m1_f,0)+ isnull(m2_f,0)+isnull(m3_f,0)+isnull(m4_f,0)+isnull(m5_f,0)+isnull(m6_f,0),
m6_d float,
m6_dz as isnull(m1_d,0)+isnull(m2_d,0)+isnull(m3_d,0)+isnull(m4_d,0)+isnull(m5_d,0)+isnull(m6_d,0),
m7_f float,
m7_fz as isnull(m1_f,0)+ isnull(m2_f,0)+isnull(m3_f,0)+isnull(m4_f,0)+isnull(m5_f,0)+isnull(m6_f,0)+isnull(m7_f,0),
m7_d float,
m7_dz as isnull(m1_d,0)+isnull(m2_d,0)+isnull(m3_d,0)+isnull(m4_d,0)+isnull(m5_d,0)+isnull(m6_d,0)+isnull(m7_d,0),
m8_f float,
m8_fz as isnull(m1_f,0)+ isnull(m2_f,0)+isnull(m3_f,0)+isnull(m4_f,0)+isnull(m5_f,0)+isnull(m6_f,0)+isnull(m7_f,0)+isnull(m8_f,0),
m8_d float,
m8_dz as isnull(m1_d,0)+isnull(m2_d,0)+isnull(m3_d,0)+isnull(m4_d,0)+isnull(m5_d,0)+isnull(m6_d,0)+isnull(m7_d,0)+isnull(m8_d,0),
m9_f float,
m9_fz as isnull(m1_f,0)+ isnull(m2_f,0)+isnull(m3_f,0)+isnull(m4_f,0)+isnull(m5_f,0)+isnull(m6_f,0)+isnull(m7_f,0)+isnull(m8_f,0)+isnull(m9_f,0),
m9_d float,
m9_dz as isnull(m1_d,0)+isnull(m2_d,0)+isnull(m3_d,0)+isnull(m4_d,0)+isnull(m5_d,0)+isnull(m6_d,0)+isnull(m7_d,0)+isnull(m