lyfz_repos/经典版源码/document/数据库维护脚本/删除已知订单号的重复景点.sql

--删除完全重复的dindanjd表记录，已知订单号的情况下;
use db
declare @order nvarchar(50)
declare @scenery nvarchar(50)
declare @autoid int
declare @count int

set @order = '20150118-001'
set @scenery = '内景'
select @count = count(*) from dindanjd where id = @order and name = @scenery
if (@count > 0 )
begin
--将指定的订单号记录插入到dindanjd_cc表里;
select identity(int,1,1) as atid,* into dindanjd_cc from dindanjd where id = @order and name = @scenery

--删除dindanjd表里的订单;
delete from dindanjd where id = @order and name = @scenery

select @autoid = min(atid) from dindanjd_cc

--重装取回一条记录插入到dindanjd表中;
insert into dindanjd ([id]
           ,[name]
           ,[date]
           ,[time]
           ,[waiter1]
           ,[waiter2]
           ,[status]
           ,[waiter12]
           ,[waiter22]
           ,[bookingdate]
           ,[dress]
           ,[bz]
           ,[clerk]
           ,[inputtime]
           ,[branch]) 
			select [id]
           ,[name]
           ,[date]
           ,[time]
           ,[waiter1]
           ,[waiter2]
           ,[status]
           ,[waiter12]
           ,[waiter22]
           ,[bookingdate]
           ,[dress]
           ,[bz]
           ,[clerk]
           ,[inputtime]
           ,[branch]
		    from dindanjd_cc where atid = @autoid

--删除临时表;
drop table dindanjd_cc
end