Microsoft SQL Server forum - Fast Date Ranges Without Loops In SQL Server 2000

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Fast Date Ranges Without Loops In SQL Server 2000

SQL

2005-09-27, 8:24 pm

The trick is to use a pivot table

Check out the code here

http://sqlservercode.blogspot.com/2...ops-in-sql.html

dbahooker@hotmail.com

2005-09-28, 11:23 am

technically that does have a loop right?

SQL

2005-09-28, 11:24 am

To populate the table yes, but that's a one time thing

I was talking specifically about the select statement

http://sqlservercode.blogspot.com/

SQL

2005-09-28, 8:24 pm

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/

Sponsored Links