Hi!



I want to select distinct month from the database table. How can i do that anyone can help me.

my database table records are as



Transaction_Date(mm/dd/yyyy)

01/01/2009

01/15/2009

01/25/2009

02/05/2009

02/20/2009

02/29/2009

03/10/2009

03/15/2009

03/28/2009

04/15/2009

04/22/2009

04/27/2009



using where statement less than today(05/01/2009) date



example

month

01

02

03

04






Max

Using the Northwinds SQL database as an example, this should work

SELECT DISTINCT MONTH(OrderDate) AS [Month]
FROM         Orders
WHERE     (OrderDate < CONVERT(DATETIME, '1996-09-03 00:00:00', 102))
ORDER BY [Month]

The problem is if you have records from previous years, then this means you have possibilty to have rows from December,2008.

Then you will have a list beginning from 1 to 12

Perhaps the query might have a starting date criteria or a year criteria for OrderDate

SELECT

DISTINCT MONTH(OrderDate) AS [Month]

FROM Sales.SalesOrderHeader

WHERE OrderDate < GETDATE() and YEAR(OrderDate) = YEAR(GETDATE())

ORDER BY [Month]

 

Eralper
ASP.NET, SQL Server & Windows 7