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.
Saving procedure results to CSV
SQL Policy to enforce object naming standards across User Databases
Hiding the login sa to one of the users
Transpose 1 column to a header
How to aggregate rows with several similar columns?