select count(adj_code), adj_code, adj_desc, sum(amount) from REPORT_ADJUSTMENT WITH(NOLOCK) inner join REF_ADJUSTMENT_CODES...
on REPORT_ADJUSTMENT.adjustment_code = REF_ADJUSTMENT_CODES.adj_code
But receive the following:
"The sum or average aggregate operation cannot take a varchar data type as an argument"
Dig Deeper on SQL-Transact SQL (T-SQL)
Related Q&A from Greg Low
Find how to query in SQL Server to get all database names created by users. Continue Reading
Learn why using the sp_OACreate stored procedure with a SQL Server 2005 trigger, is likely to result in a permissions problem. 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.