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.
| Author |
Topic |
|
Zul
Starting Member
17 Posts |
 Posted - 2009-06-02 : 22:32:14
|
| Hi Alli have database for analysis service that in the database has field raise_date.i'm using Dundas for reporting. in dundas if we chose raise date so the display data is april agusustus .... septembercan you show me how the raise date can display by month (january, february, march.... desember)ThanksZul |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-03 : 13:36:08
|
| what does raise_date store? month names or month numbers? you should be ordering by month number to get january,febrauary,... |
 |
|
|
Zul
Starting Member
17 Posts |
Posted - 2009-06-03 : 21:52:42
|
| im using raise_date with month numbers. in month field i'm using varchar data type, can varchar type short by month? |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-06-04 : 03:16:15
|
| order cast(raise_date as int)MadhivananFailing to plan is Planning to fail |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-04 : 13:27:52
|
quote:
Originally posted by madhivanan
order by cast(raise_date as int)MadhivananFailing to plan is Planning to fail
|
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-04 : 13:28:05
|
| or justorder by raisedate*1 |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-06-04 : 14:54:16
|
or justorder by raisedate+0SCNR 
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-06-05 : 02:13:15
|
| http://sqlblogcasts.com/blogs/madhivanan/archive/2008/07/21/ordering-interger-values-stored-in-varchar-column.aspxMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Short Month