I asked a question a few days back which I need to try and expand on (original question here http://www.experts-exchange.com/Database/MS-SQL-Server/SQL_Server_2008/Q_28378788.html
So this works great for the one date, however I want to compare different statuses against different dates. so for example I want my table to look like this
Today Yesterday Week Month
StatusA (date recorded)
StatusB (date updated)
StatusC (Date Sent Out)
StatusD (Date Live)
I have a column for each of these dates, and one column called Status.
Is this possible?