T-SQLhttp://sqlserver.ro/forums/15/ShowForum.aspxenCommunityServer 2.1 SP2 (Build: 61129.1)Re: Rotunjirehttp://sqlserver.ro/forums/thread/9655.aspxWed, 07 May 2014 15:35:24 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:9655xmldeveloper0http://sqlserver.ro/forums/thread/9655.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=9655O solutie este folosirea CEILING: <br /> <br />DECLARE @X DECIMAL(10,2)=835 <br />DECLARE @Y DECIMAL(10,2)=30 <br />DECLARE @Z DECIMAL(10,2)=15 <br />SELECT CEILING(@X / @Y * @Z)Re: Rotunjirehttp://sqlserver.ro/forums/thread/9648.aspxMon, 28 Apr 2014 13:53:53 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:9648ssandu0http://sqlserver.ro/forums/thread/9648.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=9648Vad ca daca fac 835 * 15 / 30 da rezultatul asteptatRotunjirehttp://sqlserver.ro/forums/thread/9647.aspxMon, 28 Apr 2014 09:49:55 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:9647ssandu0http://sqlserver.ro/forums/thread/9647.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=9647Salut <br />Cum pot rotunji din TSQL <br />835 / 30 * 15 sa dea 418 <br />Oricum am dat pana acum iese 417, iar beneficiarul imi tot arata cu un calculator de buzunar ca face 418. <br />Mentionez ca rezultatul final se rotunjeste la intregi (0 zecimale).