SQL Server, division returns zero

by

Either declare set1 and set2 as floats instead of integers or cast them to floats as part of the calculation:

SET @weight= CAST(@set1 AS float) / CAST(@set2 AS float);

More Related Contents:

  1. How to delete the records by using SQL [closed]
  2. How do I obtain a Query Execution Plan in SQL Server?
  3. MySQL: Alternatives to ORDER BY RAND()
  4. Left Join With Where Clause
  5. Remove Identity from a column in a table
  6. efficient way to implement paging
  7. How to select unique records by SQL
  8. SQL Server – transactions roll back on error?
  9. Key value pairs in relational database
  10. Difference between a User and a Login in SQL Server
  11. For Nvarchar(Max) I am only getting 4000 characters in TSQL?
  12. Record returned from function has columns concatenated
  13. Rails 3 execute custom sql query without a model
  14. How to Select a substring in Oracle SQL up to a specific character?
  15. passing table and column name dynamically using bind variables
  16. Conditional SUM on Oracle
  17. SQL Use alias in Where statement
  18. PostgreSQL JOIN with array type with array elements order, how to implement?
  19. Trim trailing spaces with PostgreSQL
  20. Nth max salary in Oracle
  21. What does sp_reset_connection do?
  22. Replace first occurrence of substring in a string in SQL
  23. How to correctly insert newline in nvarchar [duplicate]
  24. Check whether string is a date Postgresql
  25. How to measure the execution time of a query on Spark
  26. How do you copy a record in a SQL table but swap out the unique id of the new row?
  27. Using IF ELSE statement based on Count to execute different Insert statements
  28. Convert bigint to datetime
  29. Replacing NULL and empty string within Select statement
  30. Why isn’t row level security enabled for Postgres views?

Leave a Comment