Posted by SQL on 09/27/05 21:37

The trick is to use a pivot table

Check out the code here

http://sqlservercode.blogspot.com/2005/09/fast-date-ranges-without-loops-in-sql.html

• Next in forum: Job invoked by Alert but Alert never occured
• Prev in forum: Howto setup my user in order to grant him the drop privilege
• Thread view: Fast Date Ranges Without Loops In SQL Server 2000

[Reply to this message]