I am trying to create a query in SQL Server that will generate a list of dates starting from Jan 1 2007 and ending Dec 31. I have been able to get them in columns, but I want to get them in rows. Please note that I need the query to dynamically generate the data I want to avoid creating tables. Is this possible using just a query? Please help.
February 3, 2006 3:23 PM
February 6, 2006 3:15 AM