right align numbers in table / view
ok, newbie question ...
using SS v2005. When I open a table or a view the numerical fields are left aligned? I would have thought they should be right aligned by default ? i.e. like in Access 2003/2007?
how do I right align numbers in a table or view
using SS v2005. When I open a table or a view the numerical fields are left aligned? I would have thought they should be right aligned by default ? i.e. like in Access 2003/2007?
how do I right align numbers in a table or view
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
adathelad
I'd echo what Maxi84 said, and I'd have to question why it's an issue? But to offer a workaround, you could just copy/export the results into Excel.
ASKER
thanks Maxi, most of the times the data will be presented in views to a Front End or report.
Adathelad, well I would think that is obvoius, because it is easier for the human eye to look at numbers right justfied :
171.105
151.231
120.503
122.91
119.359
132.279
27.04
118.272
109.75
111.85
101.621
95
5.5021
100.248
97.1796
109.87
28.889
Access and Excel do by default, so part of the Microsoft crowd agrees with me!
Adathelad, well I would think that is obvoius, because it is easier for the human eye to look at numbers right justfied :
171.105
151.231
120.503
122.91
119.359
132.279
27.04
118.272
109.75
111.85
101.621
95
5.5021
100.248
97.1796
109.87
28.889
Access and Excel do by default, so part of the Microsoft crowd agrees with me!
You misunderstood my point (or rather I didn't answer clearly enough!) - I totally agree with numbers justified to the right being easier to read + being the standard alignment and wasn't querying the point of that aspect. It does beg the question, why doesn't MS implement the same in SQL Server as (e.g. Excel, Access) as you asked....my point was was more based on the fact that OK, it would be nice/ideal if it did align to the right, but the whole point of SSMS/Query Analyser isn't as an end-user day to day UI that will display things in pretty/customised fashion - i.e. was trying to identify if you're using it for that purpose, when you should be doing this in the presentation layer. If the display/formatting like this in SQL Server was an issue, it comes across as if you're using it for some end-user purpose.
Not sure if I've clarified my response, or muddied the water further still!
Not sure if I've clarified my response, or muddied the water further still!
ASKER
hi adathelad
no problem..
no, not 'really' using for presentation viewing, sorry I should have been clearer. I say not 'really' for I mysefl being the developer do look at a table more often in the SSMS/QA (to wit, if they supply a viewer why not look at the data?) and it is not easy to look at some data that way, espeicailly the real example I gave.
Less so, I have some advanced users that will be using the SSMS/QA to do ad hoc queries, again, to look at the data rather than thru the front end. But they won't be looking at the data that way day-to-day and will be even more reason for me nattering at them 'don't open tables directly, use a query view in SSMS/QA or the Front End or do a query in the FE.
thanks, i'm a newbie with SQLServer and was surprised at this.
no problem..
no, not 'really' using for presentation viewing, sorry I should have been clearer. I say not 'really' for I mysefl being the developer do look at a table more often in the SSMS/QA (to wit, if they supply a viewer why not look at the data?) and it is not easy to look at some data that way, espeicailly the real example I gave.
Less so, I have some advanced users that will be using the SSMS/QA to do ad hoc queries, again, to look at the data rather than thru the front end. But they won't be looking at the data that way day-to-day and will be even more reason for me nattering at them 'don't open tables directly, use a query view in SSMS/QA or the Front End or do a query in the FE.
thanks, i'm a newbie with SQLServer and was surprised at this.