Advertisement
Guest User

Untitled

a guest
Aug 1st, 2017
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.66 KB | None | 0 0
  1. SET NOCOUNT ON;
  2.  
  3. DECLARE @FromUpdateId integer = 9999;
  4.  
  5. DECLARE @Result AS table (ObjectId integer PRIMARY KEY);
  6. DECLARE @ObjectId integer;
  7. DECLARE @Found integer = 0;
  8.  
  9. WHILE @Found < 100
  10. BEGIN
  11.      SELECT TOP 1
  12.         @ObjectId = U1.ObjectId, @FromUpdateId = U1.UpdateId
  13.     FROM dbo.Updates AS U1
  14.     WHERE
  15.         U1.UpdateId > @FromUpdateId
  16.     ORDER BY
  17.         U1.UpdateId ASC;
  18.  
  19.     INSERT @Result (ObjectId)
  20.     SELECT @ObjectId
  21.     EXCEPT
  22.     SELECT R.ObjectId FROM @Result AS R;
  23.  
  24.     IF @@ROWCOUNT = 1
  25.     BEGIN
  26.         SET @Found += 1;
  27.         IF @Found % 100 = 0 RAISERROR ('Found %i', 0, 1, @Found) WITH NOWAIT;        
  28.     END
  29. END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement