Count without duplicate RRS feed

  • Question

  • Hi all :)

    In a table, i have a datetime field and a total field.

    There are some possible scenario:

    myDate               Total
    01/08/2008        12.45
    01/08/2008        P
    01/08/2008        0
    01/08/2008        null

    i need to count only the values not null, > 0 and not "P" or whatever char. As the above scenario, my count would be 1.

    Any suggest?

    Than you all.


    Wednesday, August 6, 2008 1:37 PM