Advertisement

06.02.2007 at 12:38PM PDT, ID: 22609039
[x]
Attachment Details

SQL SERVER 2005 Format Decimal Places

Asked by vstack in SQL Server 2005

Tags: sql, decimal, server, format, places

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.TotalMinutesPlayed 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

VinceStart Free Trial
[+][-]06.02.2007 at 12:39PM PDT, ID: 19201440

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: SQL Server 2005
Tags: sql, decimal, server, format, places
Sign Up Now!
Solution Provided By: angelIII
Participating Experts: 1
Solution Grade: A
 
 
[+][-]06.02.2007 at 08:20PM PDT, ID: 19202722

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32