id Attendate 1 5/25/2012 12:00:00 AM 2 6/25/2012 12:00:00 AM 3 9/25/2012 12:00:00 AM 4 5/25/2012 12:00:00 AM 5 7/25/2012 12:00:00 AM 6 8/25/2012 12:00:00 AM 7 9/25/2012 12:00:00 AM 8 5/25/2012 12:00:00 AM 9 6/25/2012 12:00:00 AM 10 8/25/2012 12:00:00 AM
153
SELECT DATEDIFF( (select top 1 AttenDate from myTable orderby AttenDate Desc) (select top 1 AttenDate from myTable orderby AttenDate Asc) GETDATE()) AS NumberOfDays This should give you the difference between the maximum and minimum dates in your table. You could optimize this query by using JOIN. You can try that out for yourself.
SELECT SUM(DATEDIFF(DAY, DATEADD(DAY, 1 - DAY(Attendate), Attendate), DATEADD(MONTH, 1, DATEADD(DAY, 1 - DAY(Attendate), Attendate)))) FROM MyTable
select datediff(day,(select top 1 Attendate from table order by Attendate asc) ,(select top 1 Attendate from table order by Attendate desc))
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)