Ordering Months in Calendar Order

[bassrider]

Hi There,

I am trying to order my months in calendar format (Jan, Feb, Mar...), but I can not. It only shows in alphabetical order (Apr,Aug,Dec..) .
Does anyone now how I can change the order from alphabetic to calendar order?

Thanks in advance...

[Jim Doherty]

Hi There,

I am trying to order my months in calendar format (Jan, Feb, Mar...), but I can not. It only shows in alphabetical order (Apr,Aug,Dec..) .
Does anyone now how I can change the order from alphabetic to calendar order?

Thanks in advance...

How are you arriving at your month values? if they derived from a formatting a date field then simply create a view that looks at that date field and expresses it as a month like this

MonthNum: MONTH(NameOfYou rDateField])

This will then give you the numeric 1 - 12 values that you can sort on

So a typical select SQL statement would look something like this in a view (or stored procedure)

SELECT FirstName,Surna me,DateOfBirth, MONTH([DateOfBirth]) as MonthNum FROM dbo.tblMyTable

You then get the extra column useful for sorting your recordset in the manner you need, in your displayed recordset when the view is run


Jim

[deepuv04]

Hi There,

I am trying to order my months in calendar format (Jan, Feb, Mar...), but I can not. It only shows in alphabetical order (Apr,Aug,Dec..) .
Does anyone now how I can change the order from alphabetic to calendar order?

Thanks in advance...

try the following example ...
will help you


declare @table table (id int,date datetime)

select DATENAME(month, CONVERT(datetim e,getdate(), 113))
insert into @table values(1,getdat e())
insert into @table values(2,datead d(month,1,getda te()))
insert into @table values(4,datead d(month,2,getda te()))
insert into @table values(3,datead d(month,3,getda te()))
insert into @table values(6,datead d(month,4,getda te()))
insert into @table values(5,datead d(month,5,getda te()))

--select * from @table

select id,convert(varc har(3),datename (month,date)) from @table order by date

thanks