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/