Please Help Me .Float DataType

• hoseini_akram

  SSC Enthusiast

  Points: 139

  More actions

  August 3, 2012 at 5:01 am

  #279821

  I got a new field called DailyCocumption by Float DataType defined.

  The field is divided into two types of fields in the table comes from Integer. With the following command:

  update dbo.tblgas01g4c40

  set DailyConsumption = Consumption/FindDiffRead where (FindDiffRead<>0)

  If the field values ​​and the Daily All times are Integer divided 30/50 to be 0.6 Show, the table shows zero.

  It defines the type of float, the elephant, but if you Integer shows.

  please help me,thanks.

• Phil Parkin

  SSC Guru

  Points: 246986

  More actions

  August 3, 2012 at 6:43 am

  #1521350

  Duplicate post. Replies here.

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel