quote:

---

Originally posted by arkiboys

Both the following select and set return correct values here

declare @Value decimal(20, 10) = 87.8764566
declare @ValuePrevious decimal(20, 10) = 86.48456540

select
((@Value - @ValuePrevious)/@ValuePrevious) * 100

set @ValueFinal = ((@Value - @ValuePrevious) / @ValuePrevious) * 100.0
print @ValueFinal

I am using a cursor with the above set statement
I can not see why in my cursor the set returns 0.0000000000
Do you see why please?

---