I am starting a new job working with some previous SSRS reports and the person previous to me has, in the dataset SQL, several spots where they have
CAST(SUM(CAST(MyFieldNameHere As Decimal(21,4))) As Decimal(21,4))
The original field is Decimal(19,4) in the table but I don't see why they would have to cast it twice to 21,4. Any good reason that anyone can think of?
We're using SQL 2017 or 2017 Compatibility, not sure exactly.