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 2008 Forums
 Transact-SQL (2008)
 How to Ordered month wise

Author  Topic 

shinelawrence
Starting Member

32 Posts

Posted - 2013-02-06 : 00:10:15
Hi Everyone,
I have one table, In my table column i have all months. When i get the table the months are not ordered.... I tried but some conversion error thrown...My fields are all varchar datatype...
I got this error only:
Conversion failed when converting date and/or time from character string.

How to do...Please tell the solution...

Thanks In Advanced

Lawce

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2013-02-06 : 00:13:57
how does your data looks like ?


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-02-06 : 00:17:46
do you've a date field?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -