摘要： 1.建立存储过程create procedure s_memberasdeclare @su intselect @su = sumu from ( select count(uniqueid) as count,sum(balance) as sumu from mem_localmemberbaseinfo group by uniqueid having count(uniqueid)>1) xreturn @su2.调用存储过程declare @sum_m intexecute @sum_m=s_memberselect @sum_m 阅读全文