Sql Mathematical calculations [closed]

by

Well, the error message is pretty clear. The idea of “summing” strings just doesn’t make sense. If numbers are really being stored in a string representation, just use cast:

select sum(cast(column as float))

More Related Contents:

  1. How to create a specific SQL Server stored procedure? [closed]
  2. Passing a varchar full of comma delimited values to a SQL Server IN function
  3. SQL update query using joins
  4. Difference between numeric, float and decimal in SQL Server
  5. T-SQL: Deleting all duplicate rows but keeping one [duplicate]
  6. Querying data by joining two tables in two database on different servers
  7. SQL: IF clause within WHERE clause
  8. “CASE” statement within “WHERE” clause in SQL Server 2008
  9. SQL Server – How to lock a table until a stored procedure finishes
  10. Where value in column containing comma delimited values
  11. How to use table variable in a dynamic sql statement?
  12. How to create a unique index on a NULL column?
  13. Search text in stored procedure in SQL Server
  14. What happens to an uncommitted transaction when the connection is closed?
  15. Create Trigger to log SQL that affected table?
  16. Difference between datetime and timestamp in sqlserver? [duplicate]
  17. Sequence vs identity
  18. Cannot use UPDATE with OUTPUT clause when a trigger is on the table
  19. SQL grouping by month and year
  20. “IN” clause limitation in Sql Server
  21. Meaning of square brackets [] in MS-SQL table designer? [duplicate]
  22. Reference an alias elsewhere in the SELECT list
  23. Selecting first row per group
  24. How do I specify date literal when writing SQL query from SQL Server that is linked to Oracle?
  25. SQL Server Convert integer to binary string
  26. How to find column names for all tables in all databases in SQL Server
  27. SQL Row_Number() function in Where Clause
  28. SQL update trigger only when column is modified
  29. Passing dynamic order by in stored procedure
  30. Export table data from one SQL Server to another

Leave a Comment