Advertisement
Guest User

Untitled

a guest
Jul 19th, 2017
49
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.28 KB | None | 0 0
  1.  
  2. SELECT DISTINCT Procera.ip, SUM(Procera.total)+(SELECT total FROM ProceraNow WHERE ip = Procera.ip) AS 'Usage'
  3. FROM Procera JOIN ActiveLease
  4.     ON Procera.ip = ActiveLease.ip AND Procera.date = ActiveLease.date
  5. WHERE Procera.date LIKE '02/%'
  6. GROUP BY Procera.ip
  7. ORDER BY 'Usage' DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement