tag:blogger.com,1999:blog-3739073232502260520.post3222801315957526289..comments2024-03-19T05:33:41.848-07:00Comments on Dinesh's Blog :::: Being Compiled ::::: SQL Server - Rounding Off Decimal to 0.5Dinesh Priyankarahttp://www.blogger.com/profile/03528311189201964690noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-3739073232502260520.post-16027025696737209742017-01-31T09:05:13.189-08:002017-01-31T09:05:13.189-08:00Excellent! Thank you very much for sharing it Herm...Excellent! Thank you very much for sharing it Hermann, it looks like it works with my requirement.Dinesh Priyankarahttps://www.blogger.com/profile/03528311189201964690noreply@blogger.comtag:blogger.com,1999:blog-3739073232502260520.post-49177212078751898872017-01-31T03:45:07.264-08:002017-01-31T03:45:07.264-08:00Hi Dinesh,
You should be able to do some magic w...Hi Dinesh, <br /><br />You should be able to do some magic with the below (substituting 3.8 for your number).<br /><br />SELECT ROUND((3.8) * 2, 0) / 2 <br /><br />It might not work exactly for what you require, but will work in most cases. dhlotterhttps://www.blogger.com/profile/13892189390072484966noreply@blogger.com