[Solved] SQL Server sum returns concatenated value

Question

Summation giving wrong valuesNORTH94779477NORTH96579657SELECT Stream Eg1 sstg1 sceng1 mathg1 Eg1  sstg1  sceng1  mathg1 AS TotalFROM dboStudentReportP1P7please help

dharmendr · Accepted Answer

Columns are considered as varchar datatype and concatenated as stringConvert column value to integer datatype in the select query

[Solved] SQL Server sum returns concatenated value

Company

Explore

Follow us

Contact Us

NORTH	9	4	7	7	9477
NORTH	9	6	5	7	9657