Post reply

Count of float and integer datatypes that are not default of 0.00 and 1

  • March 2, 2007 at 11:20 am

    #153464

    Hi -

    I'm doing a report that shows the percentage of fields in several tables that are populated.  The varchar columns are working fine, but not the integer, default 1, or float, default 0.  No matter what I try I am still getting the defaults counted. 

    Any help would be appreciated.

    Thanks,

  • March 2, 2007 at 1:19 pm

    #692929

    Replace default values with NULL. As it should always be.

    COUNT does not take NULLs.

    _____________
    Code for TallyGenerator

  • March 2, 2007 at 1:28 pm

    #692931

    Hi -

    Thanks -

    I can't change the application defaults.  Can I include something in the query that will effectively do the same thing? 

  • March 2, 2007 at 1:40 pm

    #692932

    NULLIF(ColName, )

    _____________
    Code for TallyGenerator

  • March 2, 2007 at 3:48 pm

    #692945

    Thanks so much, Sergiy - exactly what I need!  Really appreciate it.

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

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