select
T0.U_ItemCode,
T0.U_ItemName,
T0.U_Forecast,
SUM(T0.U_mrpqty)'Simulated Qty',
(select sum(onHand) from OITW T1 where T1.ItemCode = T0.U_itemcode) 'Current Quantity',
(select T3.ItmsGrpNam from OITM T2 inner join OITB T3
on T2.ItmsGrpCod = T3.ItmsGrpCod where T2.ItemCode = T0.U_itemcode)'Item group name'
from [dbo].[@QUOTA1] T0
where T0.U_ItemCode >= '[%0]' and T0.U_ItemCode <= '[%2]'
and T0.U_Forecast = '[%1]'
group by
T0.U_itemcode,
T0.U_itemname,
T0.U_Forecast
When I run this query in SQL server 2008, in 'Simulated Qty' and Current Quantity the values are coming like 0.002084
6 decimal places after point, but in SAP B1, it comes .00