IsCurrent Column In SQL
<p>I have a schema similar to this:</p>

<pre><code>ID     UserID      DateApplied     IsCurrent
1      1           2016-07-01      0
2      2           2016-07-05      0
3      1           2016-07-04      0
4      1           2016-07-10      1
5      2           2016-07-07      1
</code></pre>

<p>Is there a way to make the IsCurrent column a calculated column which is true for the maximum date for each user.</p>

<p><strong>Ie:</strong> Each time the table is updated when a new record is added, the newest record will have the current (most recent) DateTime, which should make the IsCurrent column true.</p>