SQLServer中用存储过程去除表中重复客户信息

最新推荐文章于 2021-02-27 10:58:26 发布

boboo_2000_0

最新推荐文章于 2021-02-27 10:58:26 发布

阅读量1.1k

点赞数

分类专栏：数据库技术文章标签： sqlserver 存储 delete

本文链接：https://blog.csdn.net/boboo_2000_0/article/details/4895231

版权

本文介绍了一个在SQLServer中删除表中重复客户信息的存储过程。该存储过程通过游标遍历所有重复的客户ID，保留其中一个记录，删除其余重复项，从而实现数据的去重。

摘要由CSDN通过智能技术生成

以下是本人在建立多维数据集时对重复客户信息处理所采用的存储过程:

create procedure Sp_DeleteDuplicateCustomerInfo
as
declare @CustomerId bigint
declare @Count int
declare @TopCount int
declare @StrCustomerId char(7)
declare @StrTopCount char(1)

declare deleteCur cursor for
select CustomerId,count(customerID) counts from T_CustomerInfo group by customerID
having count(customerID)>1
open deleteCur
fetch next from deleteCur into @CustomerId,@Count
while @@fetch_status=0
begin
  set @TopCount=@Count-1
  set @StrCustomerId = cast(@CustomerId as char(7))
  set @StrTopCount = cast(@TopCount as char(1))
  print 'delete from T_CustomerInfo where recId in
  (select top '+cast(