"Server: Msg 409, Level 16, State 2, Procedure CrBacSetSumFields, Line 35 The sum or average aggregate operation cannot take a varchar data type as an argument."
I'm not sure how to get it around because the table names the field as a numeric type. I would like to affirm that only the input parameter is a varchar. There is also no way to put the actual column name in the stored procedure. The column name must be taken as a parameter. Can you give me a solution?
Dig Deeper on SQL Server Stored Procedures
Related Q&A from Greg Low
Should developers be granted permissions to production queue in a SQL Server environment? See why expert Greg Low suggests proc access by WITH ... Continue Reading
If you're working with SQL Server 2000 and trying to find a disabled index, here's something you should know. Continue Reading
Find how to save stored procedure output to the network drive via SQL Server Management Studio. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.