查询一张表中只有本月数据求半年的报表的sql

SELECT glzb_name,recdate,product_id,b_flag,SUM(amt) AS sg_amt INTO #temp FROM product..of_match_glzb   WHERE b_flag=0 GROUP BY recdate,product_id,glzb_name,b_flag  SELECT glzb_name,recdate,product_id,b_flag,SUM(amt) AS sh_amt INTO #temp2 FROM product..of_match_glzb   WHERE b_flag=1 GROUP BY recdate,product_id,glzb_name,b_flag  SELECT  a.glzb_name,a.recdate,a.product_id,a.sg_amt,b.sh_amt INTO  #temp3 FROM #temp a JOIN #temp2 b ON    a.recdate=b.recdate AND a.product_id=b.product_id AND a.glzb_name=b.glzb_name     SELECT glzb_name AS 分公司,product_id AS 产品代码,  SUM(CASE WHEN recdate =@bdate THEN data ELSE 0 END ) AS '查询本月',  SUM(CASE WHEN recdate =@qygy THEN data ELSE 0 END ) AS '前一个月',  SUM(CASE WHEN recdate =@qlgy THEN data ELSE 0 END ) AS '前两个月',  SUM(CASE WHEN recdate =@qsgy THEN data ELSE 0 END ) AS '前三个月',  SUM(CASE WHEN recdate =@qsgy4 THEN data ELSE 0 END ) AS '前四个月',  SUM(CASE WHEN recdate =@edate THEN data ELSE 0 END ) AS '前五个月'  FROM  (  SELECT glzb_name,product_id,recdate, ROUND(sg_amt-sh_amt,2) AS data   FROM #temp3 WHERE  recdate BETWEEN @edate AND @bdate ) as tep WHERE product_id=@procode  GROUP BY  glzb_name,product_id    DROP TABLE #temp  DROP TABLE #temp2  DROP TABLE #temp3