my currently percentage is calculating like 10.45454545% but i want 10.45% ,
below is my store procedure
ALTER Procedure [dbo].[Sp_Belt_Sumlb]
@StartDate Datetime,
@EndDate Datetime
as
Begin
;with cte1
AS
(
SELECT
ISNULL(SUM(case when b.prdQTY is null
then 0 else i.weight end ),0)Small_Bale_weight
FROM ItemMasterFile i
LEFT OUTER JOIN Probale b ON i.CodeItem = b.CodeItem
where (b.DelID is null and b.Entrydate BETWEEN
@StartDate AND @Enddate or b.EntryDate is null) )
,cte
as
(SELECT ( SELECT isnull(SUM(IWeight),0) FROM ConIssuance
where EntryDate between @StartDate and @EndDate ) +
(SELECT isnull(SUM(R_Weight),0) FROM Tlb_Rags where R_EntryDate between
@StartDate and @EndDate)as belts,Small_Bale_weight
From cte1)
select (isnull(nullif(Small_Bale_weight,0)*100.0/nullif(belts,0),0))
From cte
where Small_Bale_weight+belts<>0
group by cte.Small_Bale_weight,belts
end
