Guest User

Untitled

a guest
Nov 20th, 2017
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.36 KB | None | 0 0
  1. select
  2. year 1,count(*),
  3. year 2, count(*)
  4. From db
  5. WHERE year1 >= DATEADD(yy,-1,DATEADD(yy,DATEDIFF(yy,0,GETDATE()),0))
  6. AND year1 <= DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()) - 12, 0)
  7. AND
  8. year2 >= DATEADD(yy,0,DATEADD(yy,DATEDIFF(yy,0,GETDATE()),0))
  9. AND year2 <= DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()) , 0)
  10.  
  11. 2016 Units 2017 units
  12. 3000 1200
Add Comment
Please, Sign In to add comment