title: Compare current date with stored datetime using month an year only
body: <p>Using SQL Server 2005 I have a field that contains a datetime value.</p>
  
  <p>What I am trying to do is create 2 queries:</p>
  
  <ol>
  <li>Compare to see if stored datetime is of the same month+year as current date</li>
  <li>Compare to see if stored datetime is of the same year as current date</li>
  </ol>
  
  <p>There is probably a simple solution but I keep hitting brick walls using various samples I can find, any thoughts?</p>
  
  <p>Thanks in advance.</p>