• Oh, and here are my favo(u)rite date links (so to speak)...

     

    http://www.sql-server-performance.com/articles/dev/datetime_datatype_p1.aspx

    http://sqlserver2000.databases.aspfaq.com/why-should-i-consider-using-an-auxiliary-calendar-table.html

    http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=64762

     

    I hope someone finds all this stuff useful...

     

    Ryan Randall

    Solutions are easy. Understanding the problem, now, that's the hard part.