>Here is a puzzle. I have a table that contains annual records for businesses. There may or may not be a record for a given business in any given year. So for BusinessA there may be records for 2000, 2003, 2004, 2008, 2010, 2012, etc. I want to SELECT the most recent 3 records. That is easy enough.
SELECT TOP 3 * FROM [HistoricalSummary] WHERE business=@business ORDER BY [year] desc
But now here's the problem. I want the order of these records to be sorted by year lowest to highest. So this is the opposite of what is needed to get the 3 latest records. Has anyone dealt with anything like this before?
>Thanks
What will you do if the year is missing, for some reason. Say, you only have data for 2013, 2012 and 2010 missing 2011. Does it matter?
If it's not broken, fix it until it is.
My Blog