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 |
|
programer
Posting Yak Master
221 Posts |
 Posted - 2010-10-15 : 18:12:19
|
| Hi,which datatype is needed if I want to display the data 1 / 2010 and want to get query = select min (number) as number ...Do I have to use a separate number and year?Regards |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2010-10-15 : 18:56:52
|
| Can you elaborate on your requirements? It sounds like you want to format a constant (1 / 2010) but then reference the Min() function.=======================================In all life one should comfort the afflicted, but verily, also, one should afflict the comfortable, and especially when they are comfortably, contentedly, even happily wrong. -John Kenneth Galbraith, economist (1908-2006) |
 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-10-16 : 07:44:10
|
Yes you should separate them.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-10-17 : 03:04:53
|
| is it date value? does 1/2010 represent Jan 2010? then you might have to convert it to date before you apply min() max() if you want sequence based on date------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Datatype of the value of 1 / 2010