Guest User

Untitled

a guest
Jun 19th, 2018
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.30 KB | None | 0 0
  1. UPDATE P
  2. SET P.Inactivity = P.Inactivity + 50,
  3. P.Processed = 1
  4. FROM dbo.Players as P
  5. LEFT JOIN ( SELECT PlayerID
  6. FROM dbo.PlayerToWar
  7. WHERE WarID = @WarID
  8. ) X
  9. ON P.PlayerID = X.PlayerID
  10. WHERE P.PlayerID = NULL and P.Processed = 0
Add Comment
Please, Sign In to add comment