Scalar Functions

The lack of a scalar function has required over 5,000 lines of code to replace what would be 12 lines of code utilizing a scaler function to perform the same calculation. Now running into the SQL Server limit of 65,535 identifiers/constant in a single expression. Microsoft needs to add this critical missing core functionality ASAP.

OR

Add options to the built-in ROUND function to allow different methods of rounding. I need ROUND(1.2345,3) to return 1.234, NOT 1.235

One of the most common rounding rules is that even numbers followed by only a 5 are not rounded up (only odd numbers are rounded up).

ROUND(1.2335,3) should (and does) return 1.234

ROUND(1.2345000005,3) should (and does) return 1.235