March 5, 2011 at 8:12 pm
I am using SQL Compact.
When trying to total a column of numbers, does the data type have to be numeric. Right now it is data type money because they are dollo=ar figures but the sum function does not total the whole column.
March 7, 2011 at 2:59 pm
vikingmanm (3/5/2011)
I am using SQL Compact.When trying to total a column of numbers, does the data type have to be numeric. Right now it is data type money because they are dollo=ar figures but the sum function does not total the whole column.
sum() function will return a money datatype value when doing a sum() on a money datatype column.
Can you be more specific about "the sum function does not total the whole column"?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply