I've got numbers like 3.32 and 3.87 that I calculate and I would like them to both round up to 4 however what I'm getting is rounding down.
Looking at some other questions that were answered I thought this might pull it off but to no avail?
CAST(ROUND(CAST(C.TRANS_QTY AS decimal(18,2)),0) AS INT) AS ROUNDED_QTY,
This does deliver a '0' decimal but it is not rounding up. i suspect I have the cast and round bits scewing with one another.