紧急求救，在线等待，存储过程问题，为什么老是说 "列名mmm无效"，100分

Question

/*计算售出金额*/             
             select  @sold_jine=isnull(sum(piaojia),0) from soldticket where year(operatetime)=@year1 and month(operatetime)=mmm and spyid=@gonghao
             /*计算合计金额*/
-->
  /*计算售出金额*/             
             select  @sold_jine=isnull(sum(piaojia),0) from soldticket where year(operatetime)=@year1 and month(operatetime)=@mmm and spyid=@gonghao
             /*计算合计金额*/

Answer 1

/*计算合计金额*/
             select  @sold_heji=isnull(sum(piaojia_source),0) from soldticket where year(operatetime)=@year1 and month(operatetime)=mmm and spyid=@gonghao
             /*计算折扣金额*/
            -->
  /*计算合计金额*/
             select  @sold_heji=isnull(sum(piaojia_source),0) from soldticket where year(operatetime)=@year1 and month(operatetime)=@mmm and spyid=@gonghao
             /*计算折扣金额*/

Answer 2

/*计算售出金额*/             
             select  @sold_jine=isnull(sum(piaojia),0) from soldticket where year(operatetime)=@year1 and month(operatetime)=mmm and spyid=@gonghao  
             /*计算合计金额*/            ......@mmm
             select  @sold_heji=isnull(sum(piaojia_source),0) from soldticket where year(operatetime)=@year1 and month(operatetime)=mmm and spyid=@gonghao
             /*计算折扣金额*/                        ......@mmm有两处mmm少@