Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databases
Fast Date Ranges Without Loops In SQL Server 2000The trick is to use a pivot table Check out the code here http://sqlservercode.blogspot.com/2...ql.ht ml
Post Follow-up to this message
Re: Fast Date Ranges Without Loops In SQL Server 2000technically that does have a loop right?
Post Follow-up to this message Re: Fast Date Ranges Without Loops In SQL Server 2000To populate the table yes, but that's a one time thing I was talking specifically about the select statement http://sqlservercode.blogspot.com/
Post Follow-up to this message Re: Fast Date Ranges Without Loops In SQL Server 2000I 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/
Post Follow-up to this message
Sponsored Links
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread
