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 |
|
dringi
Starting Member
7 Posts |
 Posted - 2006-02-13 : 15:11:26
|
| I need to create a query that modify the format of a table in percent with 2 decimals ...any idea?? |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-02-13 : 19:12:07
|
| Change your data type to numeric, with a scale of 2, you could put the extra work to format any data in your SP. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-02-14 : 03:31:18
|
| >>you could put the extra work to format any data in your SP.Did you mean Stored Procedure?MadhivananFailing to plan is Planning to fail |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-02-14 : 03:53:07
|
| Yes, Why ??? |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-02-14 : 04:58:15
|
Access doesnt directly support SP  MadhivananFailing to plan is Planning to fail |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-02-14 : 07:47:31
|
| http://www.devguru.com/Technologies/jetsql/quickref/alter_table.html |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-02-14 : 09:46:10
|
| >>Access doesnt directly support SP Silly me, i got carried away. Thinking its all about SQL Server |
|
|
|
|
|
|
Table format percent