RE: Lowell's post....results are still too high... when I try to follow your logic in the code I get lost in the syntax around "GROUP BY" so I started back at the basics. If I just do emp_id and adm_date the numbers are right...

SELECT

CONVERT (VARCHAR(9), EMPLOYEE_ID) AS EMP_id,

MAX(CONVERT(DATETIME, (CONVERT(VARCHAR(8), ADMISSION_DTE)))) AS Adm_date

from CurrentTable

WHERE [BranchID] = '950'

AND ( DISC_DTE IS NULL

OR ( DISC_DTE > 20120630

AND DISC_DTE < 20130201 ) )

GROUP BY

EMPLOYEE_ID

.... but as soon as I add in additional fields the numbers get higher and higher. ???

I'm going to try the next example.