SUM SQL Server 2008 - Could not find stored procedure SUM
I have a SQL Server 2008 table with a smallmoney field, Amount.
I am trying various ways to sum the column:
SUM([Amount]) AS Amount FROM Payment
I get the error "Could not find stored procedure SUM" I've tried to sum an Integer field as well. It's not the field I'm summing, it's the fact the SUM doesn't exist.
What's going on here?
thanks.
I am trying various ways to sum the column:
SUM([Amount]) AS Amount FROM Payment
I get the error "Could not find stored procedure SUM" I've tried to sum an Integer field as well. It's not the field I'm summing, it's the fact the SUM doesn't exist.
What's going on here?
thanks.
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Glad to help you out..
And it happens sometimes..
And it happens sometimes..
Microsoft SQL Server 2008
Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the Always On technologies and support for unstructured data types.
50K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER
thanks LOL