HELP me with the SELECT statement , This has a GROUP BY CLAUSE

SQLServerCentral » Latest topics

HELP me with the SELECT statement , This has a GROUP BY CLAUSE

Take a look at the code.  I am interested in counting the distinct codes that a member has within a certain range.
Right now , with the data that is in the table it gives a count of  1 more than the correct count  which is 3.
( Now

more info...