SQL SERVER 2005
How do I format decimal places. A part of a stored proc calculates a goalie's goals against average
(Cast(TS.TotalGoalsAgainst
AS Decimal)/Cast(TS.TotalMinu
tesPlayed As Decimal) * 40) AS GAA
(* 40 cause there's 40 minutes in our games)
The result works but looks like:
3.00000000000000000
How do I make it look like 3.00?
Thanks
Vince
Start Free Trial