Is it possible to create dynamic dates with SQL. I want to display all the dates for a particular date range as column headers? How can it be achieved?
Pivot or crosstab. Can you provide a few more details? There's a link in my sig providing posting guidelines.
“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw