SQL Server Date Lookup

[cotton31]

I'm looking to create a 'date lookup' table i.e. a table that has various permutations of every date in a range.

What's the best way to do this? Does anyone have a script they use?

Cheers!

 

[RobH]

If you google "sql calendar table" you should find a few useful results depending on your SQL server technology. At work we have a calendar table which I make use of when calculating occupancy between specific dates.

 

[cotton31]

Cheers mate, I wasn't sure what term I should be Googling!

Your use sounds pretty much the same as what I'd be using it for!