Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Transact-SQL (2005)  Gruop By Month Print a list with links

Author  Topic  fcgp1985 Starting Member 1 Post Posted - 2008-01-17 : 14:39:07 Hello, I have a database of news with a field called "date" and the typed is DATE, and I want to create a list of items that show the month and the year, that when the user click it in the webpage, it shows the news posted that month. Kind of like an archive of news sorted by month. Can anyone help me?