Operand data type varchar is invalid for sum operator.

Question

Operand data type varchar is invalid for sum operator.

Analyst_SQL 3,576

i am facing error on below line ,want comma in value ( 48,950.00)

sum ( CONVERT(Varchar(50), Cast(tn.Debit as money),1))

Yitzhak Khabinsky 26,586 Reputation points

2021-06-04T17:16:38.027+00:00

@Analyst_SQL ,

While asking a question you need to provide a minimal reproducible example:
(1) DDL and sample data population, i.e. CREATE table(s) plus INSERT, T-SQL statements.
(2) What you need to do, i.e. logic, and your attempt implementation of it in T-SQL.
(3) Desired output based on the sample data in the #1 above.
(4) Your SQL Server version (SELECT @@version;)

Accepted answer

1 additional answer

Your answer

Yitzhak Khabinsky 26,586 Reputation points

2021-06-04T17:16:38.027+00:00

@Analyst_SQL ,

While asking a question you need to provide a minimal reproducible example:
(1) DDL and sample data population, i.e. CREATE table(s) plus INSERT, T-SQL statements.
(2) What you need to do, i.e. logic, and your attempt implementation of it in T-SQL.
(3) Desired output based on the sample data in the #1 above.
(4) Your SQL Server version (SELECT @@version;)

Answer 1

Hafeez Uddin 296

SUM can be used with numeric columns only. Null values are ignored.

Try this
CONVERT(Varchar(50), sum ( Cast(tn.Debit as money)),1))

Answer 2

Tom Cooper 8,486

Use the FORMAT function, for example
Create Table #T(Debit float);
Insert #T(Debit) Values (40000), (8950);
Select Format(Sum(Debit), 'N', 'en-us') From #T;
Tom

Share via

Operand data type varchar is invalid for sum operator.

1 additional answer

Your answer