合并数据库重复的uniqueid存储过程

1.建立存储过程

create procedure s_member
as
declare @su int
select @su = sumu from (
                  select count(uniqueid) as count,sum(balance) as sumu from mem_localmemberbaseinfo group by uniqueid
         having count(uniqueid)>1) x
return @su

2.调用存储过程

declare @sum_m int

execute @sum_m=s_member

select @sum_m