title: Get current year's records from a view in SQL Server
body: <p>I have a view called <code>vwMemberPolicyInfo</code> and I need to display all records entered in current year.</p>
  
  <p>My query is : </p>
  
  <pre><code>select  
      EffectiveDate AS [Month], 
      count(MemberID) AS Agents, 
      sum(ActualPremium) AS Premium
  from 
      vwMemberPolicyInfo 
  Where 
      EffectiveDate &gt; DATEADD(year, -1, GETDATE())
  GROUP BY 
      EffectiveDate 
  </code></pre>
  
  <p>but it is not working fine it show result:</p>
  
  <pre><code>2010-11-01 00:00:00.000 74  40644.00
  2010-07-01 00:00:00.000 86  50418.00
  
  2011-03-08 00:00:00.000 1   744.00
  2011-04-08 00:00:00.000 1   0.00
  2010-11-02 00:00:00.000 5   2676.00
  
  2011-04-14 00:00:00.000 1   1185.00
  2011-02-28 00:00:00.000 7   2988.00
  
  2011-02-23 00:00:00.000 8   8518.00
  2011-04-10 00:00:00.000 1   1332.00
  2011-04-07 00:00:00.000 3   2544.00
  </code></pre>
  
  <p>I need only the current year entries to display  ..thanks in advance </p>