tag:blogger.com,1999:blog-495177919198719500.post5670636555184885294..comments2023-12-27T20:52:29.483-08:00Comments on Microsoft Sql Server Tutorials: Automatically Round off numbers to the nearest digitSuprotim Agarwalhttp://www.blogger.com/profile/08349831623922214390noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-495177919198719500.post-67541411615690404092017-08-21T12:52:36.315-07:002017-08-21T12:52:36.315-07:00what if i do not want round values? how can i stop...what if i do not want round values? how can i stop it?KIRTAN KHATSURIYAhttps://www.blogger.com/profile/08742401301042499701noreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-51382900357327514552010-04-02T19:58:05.043-07:002010-04-02T19:58:05.043-07:00Dave: Nice point. The client did not want to chang...Dave: Nice point. The client did not want to change the sql statement. They were ok making changes in the schema instead, hence the solution. I have added that point to the post.Suprotim Agarwalhttps://www.blogger.com/profile/08349831623922214390noreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-2177209429245324742010-04-02T11:01:50.648-07:002010-04-02T11:01:50.648-07:00Seems kind of risky to rely on implied functionali...Seems kind of risky to rely on implied functionality instead of just using the Round (http://msdn.microsoft.com/en-us/library/ms175003.aspx) statement.<br /><br />Does using the temp table buy you anything else?Dave Levyhttp://adventuresinsql.comnoreply@blogger.com