Post reply

Please Help Me .Float DataType

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

  • August 3, 2012 at 6:43 am

    #1521350

    Duplicate post. Replies here.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply