• subhashacharya1 (5/27/2015)


    i don't think you need to use the count function.

    For this particular data set, you are right. But the OP's specs included this requirement:

    records that has single entry only, which has type '0'

    To make sure that happens, COUNT is very necessary.

    __________________________________________________________________________________________________________
    How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/