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 |
|
pgmr1998
Yak Posting Veteran
66 Posts |
 Posted - 2010-05-20 : 12:28:58
|
| I am creating a file from SQL code,and I am creating a new field in the file using the sum parameter. But the sum field size after I run the code is much larger than I need or want. How can I set its field size? |
|
|
lazerath
Constraint Violating Yak Guru
343 Posts |
Posted - 2010-05-20 : 13:06:16
|
| It is not clear to me what you are trying to achieve. Are you saying the number of characters resulting from a SUM(Column1) is too much? Are you getting unwanted decimal places? Please provide an example of what you are getting and what you want. |
 |
|
|
pgmr1998
Yak Posting Veteran
66 Posts |
Posted - 2010-05-20 : 13:13:44
|
| The resulting field is too large, about size of packed 30. I need only 10. |
|
|
|
lazerath
Constraint Violating Yak Guru
343 Posts |
Posted - 2010-05-21 : 13:42:27
|
| You have not answered my questions or provided examples. |
|
|
|
|
|
|
Limit Size of Calculated Field