Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SET NOCOUNT ON;
- DECLARE @FromUpdateId integer = 9999;
- DECLARE @Result AS table (ObjectId integer PRIMARY KEY);
- DECLARE @ObjectId integer;
- DECLARE @Found integer = 0;
- WHILE @Found < 100
- BEGIN
- SELECT TOP 1
- @ObjectId = U1.ObjectId, @FromUpdateId = U1.UpdateId
- FROM dbo.Updates AS U1
- WHERE
- U1.UpdateId > @FromUpdateId
- ORDER BY
- U1.UpdateId ASC;
- INSERT @Result (ObjectId)
- SELECT @ObjectId
- EXCEPT
- SELECT R.ObjectId FROM @Result AS R;
- IF @@ROWCOUNT = 1
- BEGIN
- SET @Found += 1;
- IF @Found % 100 = 0 RAISERROR ('Found %i', 0, 1, @Found) WITH NOWAIT;
- END
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement