Fast Date Ranges Without Loops In SQL Server 2000

The trick is to use a pivot table

Check out the code here

http://sqlservercode.blogspot.com/2...ops-in-sql.htmltechnically that does have a loop right?|||To populate the table yes, but that's a one time thing

I was talking specifically about the select statement

http://sqlservercode.blogspot.com/|||I have added the code to split a character string without tedious
looping but using a pivot table instead
go to my blog to look at the code

http://sqlservercode.blogspot.com/