Sum the number of days over a non-consecutive date range per emplid. Here is data example
emplid start date end date
9999999 02/01/2010 04/30/2010
9999999 09/08/2009 01/29/2010
9999999 09/07/2010 12/20/2010
The query would give the total number of days worke within the date range of Jan 1 2010 - Dec 31 2010
MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.
Why is this different from all of the other step by step guides? Because I make a living as a DBA and not as a writer and I lived through this experience.
Defining the name:
When I talk to people they say different names on this subject stuff l…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
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.