SQL SSRS updating row based on another row
<p>I have a problem which I've searched but I don't think I'm using the correct search keywords. Hoping someone help,</p>

<p>I have a table that looks like this,</p>

<pre><code>Name        YEAR
Chicken     2015
Cow         2012
Lion        2014
Lion        **2016**
Tiger       2013
Tiger       2014
Tiger       **2016**
</code></pre>

<p>Result</p>

<pre><code>Name        YEAR
Chicken     2015
Cow         2012
</code></pre>

<p>I want ALL the corresponding Name set to 'NULL' or preferably lines removed when the YEAR is 2016. So 2 lines of Lion and 3 lines of Tiger are removed because one of them has an YEAR = 2016. </p>

<p>Thank you!</p>