I like to create a query to generate a table of the latest claim for each employee since Jan 1, 2013. In the table there can be more than one records related to a EmployeeID. Records before Jan 1, 2013 will not be take into consideration.
The result should have the same column as the above table.
Can anyone give me an idea how to do that? Thanks.
I'm trying, I really am. But I've seen so many wrong approaches involving date(time) boundaries I despair about my inability to explain it. I've seen quite a few recently that define a non-leap year as 364 days, or 366 days and the list goes on.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied?
You can use SQL Server Initialize from Backup…