Finding Last 2 Dated Columns – SQL Ranking

Once again, I need to use the Transact -SQL  Rank in a query.  I must be going senile because I always have to review this function.  I don’t always use it but it comes in handy when I get asked to find the last X recorded values. Last nearly always means dated.  So just to save time looking for how to do this appropriately, I  am writing down Read more […]