CREATE TABLE #PSACCESSLOG(
	oprid	varchar(6),
	logindttm	datetime)

INSERT INTO #PSACCESSLOG 
SELECT 'jbaker', '2012-06-01 00:50:59.000' UNION ALL
SELECT 'jbaker', '2012-06-01 12:50:59.000'  UNION ALL
SELECT 'jbaker', '2012-06-01 15:50:59.000' 

SELECT oprid, 
	DATEADD( dd, DATEDIFF( dd, 0, LOGINDTTM), 0) AS LOGINDT, 
	COUNT(*) AS entries
FROM #PSACCESSLOG
WHERE LOGINDTTM BETWEEN '2012-06-01 00:50:59.000' AND '2012-07-01 00:50:59.000'
GROUP BY oprid, DATEADD( dd, DATEDIFF( dd, 0, LOGINDTTM), 0)
ORDER BY OPRID, LOGINDT

DROP TABLE #PSACCESSLOG