Stop SUM rounding SQL
<p>I am creating a SQL view using this SELECT statement:</p>

<pre><code>SELECT 
ISNULL(MONTH(DtRepairComplete), 0) AS RepairMonthNo
,ISNULL(FORMAT(DtRepairComplete, 'MMMM'), GETDATE()) AS RepairMonth
,ISNULL(YEAR(DtRepairComplete), 0) AS RepairYear
,ISNULL(SUM(IntRepairCosts), 0) AS TotalRepairCosts
,COUNT(IntIncidentID) AS RepairCount

FROM Incident d

GROUP BY FORMAT(DtRepairComplete, 'MMMM'),


YEAR(DtRepairComplete)
,MONTH(DtRepairComplete)
,FORMAT(DtRepairComplete, 'MMMM')
</code></pre>

<p>IntRepairCosts is data type decimal(18,0) on the table. When I attach the view to my project, it is rounding to whole numbers. As this value represents a cost, I need it to be accurate and not round up or down.</p>

<p>Can I stop this field from rounding and still SUM per the query?</p>

<p>Thank you in advance.</p>