--創(chuàng)建視圖
create view v1 as
select *,row_number() over (order by serialcode) as 'id' from TMP_CQ_Cmn_History
where starttime in
(select  starttime from TMP_CQ_Cmn_History where BranchNo=1 and SubCenterNo=5
 and  OperatorNo=2005 and CommentTime>'2010-01-30' group by starttime having count(starttime) >1 )
go
select * from v1

go

--定義游標(biāo)
declare @id int
declare PJ cursor for select id from v1
open PJ
fetch next from PJ into @id  WHILE (@@FETCH_STATUS=0)
begin
delete from v1 where id=1
fetch next from PJ into @id
end
CLOSE PJ
DEALLOCATE PJ