title: How to show if a donation occured in the prior year but not current?
body: <p>I'm creating a year-over-year donation report with the following schema &amp; query in Server 2012:</p>
  
  <pre><code>CREATE TABLE Donation
  (
     HouseholdID INT, 
     HouseholdName VARCHAR(150), 
     [Donation] REAL, 
     DateOrdered DATE
  );
  
  INSERT Donation VALUES
  (1,'The Smiths',50,'2011-01-01'),
  (1,'The Smiths',75,'2012-02-02'),
  (2,'The Wilsons',10,'2011-03-01'),
  (2,'The Wilsons',60,'2011-07-01'),
  (3,'The Kellys',500,'2012-06-01');
  
  --Params
  DECLARE @RunYear   INT=2012
  DECLARE @PriorYear INT=@RunYear-1
  
  SELECT 
      [HouseholdID],[HouseholdName],YEAR(DateOrdered) [Year], MAX(Donation) [MaxGift], SUM(Donation) [TotalDonated]
  FROM 
      Donation 
  WHERE 
      YEAR([DateOrdered]) IN (@RunYear,@PriorYear)
      GROUP BY HouseholdID, [HouseholdName], YEAR(DateOrdered)
      ORDER BY HouseholdID, YEAR(DateOrdered)
  </code></pre>
  
  <p>I'd like to add a <code>BIT</code> column like [DonatedInPriorYearOnly] that would be 1 only if the household had a donation in the prior year (2011) but none in the run year (2012).</p>
  
  <p>How can this be accomplished?</p>