SQLServerCentral » Latest topics
format "Floor" should change to Round
Hi,
Need to get the integer values in results.
i am using below FLOOR function , but i want to get the values to be rounded.
Query:
REPLACE(FORMAT(FLOOR(CASE WHEN sum(CASE WHEN a.LOANAMOUNT IS NOT NULL THEN a.STR_WEIGHT ELSE
Need to get the integer values in results.
i am using below FLOOR function , but i want to get the values to be rounded.
Query:
REPLACE(FORMAT(FLOOR(CASE WHEN sum(CASE WHEN a.LOANAMOUNT IS NOT NULL THEN a.STR_WEIGHT ELSE
No comments:
Post a Comment