I need a query to return the most recent status for a given client. Using SQL Server2008. There are multiple dates and multiple statuses.
The status field can include any number of statuses. I don't know what will be in that field. The query should generate a list of the existing statuses for the given client and then get the most recent date for each status.
@ClientNum = '6000'
ClientNum Date Status
6000 06/14/10 Started
6000 06/24/10 Process1
6000 07/04/10 Process2
6000 07/14/10 Finished
With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.