How do I get the following results?
I am looking to get 17000.00 from 16789.99 and 16432.99. Not sure how to do this correctly.
SELECT ROUND(16789.99, -3) AS [MYNUMBER] -- => 17000.00
SELECT ROUND(16432.99, -3) AS [MYNUMBER] -- => 17000.00
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
Answer by Kev Riley · Apr 20 at 06:55 AM
thank you that worked!
Answers Answers and Comments
15 People are following this question.
how do I create a link to a sql 2000 from sql2014
How to do sum in SQL
WMI Event Watcher task
SQL CLR questions for SQL 2014
SQL Native Client 11.0 config force protocol encryption