Convert Integer to Decimal

• airborn

  SSC Enthusiast

  Points: 183

  More actions

  February 10, 2009 at 9:11 am

  #383906

  I am trying to get my frequency to come out as 1.3, 2.8, 4.4, etc. Basically a decimal output. How would I do this?

  Declare @Month Varchar;

  Select Month, SUM(Month) as MonthlyTotal,(100 * SUM(Month)/260504) As Frequency

  From GetTotalOf1(@Month)

  Group by Month

  MonthMonthlyTotalFrequency

  13583 1

  27318 2

  311688 4

  413524 5

  516665 6

  622572 8

  727167 10

  834720 13

  938016 14

  1034790 13

  1124673 9

  1225788 9

• Ray M

  SSC-Insane

  Points: 21093

  More actions

  February 10, 2009 at 12:22 pm

  #941539

  Not sure what is in your table valued function but you can do it 2 ways

  Select Month, SUM(Month) as MonthlyTotal,(100 * SUM(convert(decimal(4,1), Month))/260504) As Frequency

  From GetTotalOf1(@Month)

  Group by Month

  OR

  Select Month, SUM(Month) as MonthlyTotal,(100 * SUM((Month* 1.0))/260504) As Frequency

  From GetTotalOf1(@Month)

  Group by Month

• airborn

  SSC Enthusiast

  Points: 183

  More actions

  February 10, 2009 at 12:32 pm

  #941549

  Thanks Ray M.

  It worked!! That's what I was looking for.