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 |
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
 Posted - 2006-07-07 : 13:57:08
|
| Is there a limit on the number of fields that I can add togheter ? I have 6 fields (numeric) that needs to be added togheter for a report, I'm doing that on a view and apparently field number 5 and 6 does not get added, any ideas why ?SELECT AName, [Day 1] + [Day 2] + [Day 3] + [Day 4] + [Day 5] + [Day 5+] AS Total, [Day 1], [Day 2], [Day 3], [Day 4], [Day 5], [Day 5+]FROM View1---Thanks!Igor. |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2006-07-07 : 14:03:17
|
| If there is a limit to the # of terms in an expression, I am sure it is larger than 5!Are any of the values potentially NULL ? If so, each should be surrounded by an ISNULL() or COALESCE() function.- Jeff |
 |
|
|
|
|
|
Adding Fields