Advertisement
Guest User

Untitled

a guest
Jun 25th, 2019
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.30 KB | None | 0 0
  1. select *from #ResultData WHERE YEAR(CONVERT(date, '01-' + Monthformat)) = YEAR(GETDATE()) - 1;
  2. --Getting current Year
  3.  
  4. select *from #ResultData WHERE YEAR(CONVERT(DATE, '01-' + Monthformat)) = YEAR(GETDATE()) AND MONTH(CONVERT(DATE, '01-' + Monthformat)) <= MONTH(GETDATE());
  5. --Getting previous Year
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement