Home Forums Article Discussions Article Discussions by Author Discuss content posted by SQL Buzz Predict the total count RE: Predict the total count

  • November 5, 2010 at 3:47 am

    #1247026

    So when the conversion into floats and then taking ceiling of the values, these 2 records generate the same values.

    I disagree with explanation, it's enough to convert to INT

    Select count(intField) from TableDate where convert(INT,datefield) = 40358