Max function in SQL Server that takes two values like Math.Max in .NET Asked 17 years, 3 months ago Modified 6 months ago Viewed 719k times

Due to precedence of SQL statements it will be the same. however, due to data types if using 100 you can still get the result rounded to 0 decimals you desire for the % where as if you put it after the …

182 The solutions using CASE, IIF, and UDF are adequate, but impractical when extending the problem to the general case using more than 2 comparison values. The generalized solution in SQL Server …

I'd like a SQL query to count each occurrence in each table (except users of course). BUT, I want some tables to carry more weight than the others. Then I want to tally up a "score". Here is an example: …

Is it possible to easily round a figure up to the nearest 100 (or 1000, 500, 200 etc.) in SQL Server? So: 720 -> 800 790 -> 800 1401 -> 1500

How to do simple math in an SQL SELECT query? Asked 13 years, 4 months ago Modified 13 years, 4 months ago Viewed 34k times

The modulus function in Microsoft SQL Server only works on certain data types. According to the MSDN Article [1] on the modulus operator, you normally would use modulus like this... dividend % di...

Aug 14, 2012 · SQL DATETIME Math Asked 13 years, 4 months ago Modified 13 years, 4 months ago Viewed 7k times

I am using Microsoft SQL Server Express 2016 to write a stored procedure. One of the requirements is to do rounding. But every now and then, the rounding is wrong. I found out that T-SQL rounding i...

Jan 27, 2012 · 5 I am using SQL Server 2008. I am trying to do some basic math in some basic queries. I need to add up wins, losses, total, and percentages. I usually ask for the raw numbers and then do …