By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,747 Members | 1,672 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,747 IT Pros & Developers. It's quick & easy.

Fast Date Ranges Without Loops In SQL Server 2000

P: n/a
SQL
The trick is to use a pivot table

Check out the code here

http://sqlservercode.blogspot.com/20...ps-in-sql.html

Sep 27 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
technically that does have a loop right?

Sep 28 '05 #2

P: n/a
SQL
To populate the table yes, but that's a one time thing

I was talking specifically about the select statement

http://sqlservercode.blogspot.com/

Sep 28 '05 #3

P: n/a
SQL
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/

Sep 28 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.