SQL Tricks
select CONVERT(CHAR(8), getdate(), 112)
20131107
select CONVERT(CHAR(8), READ_AT, 112),count(*)
FROM extract.dbo.CVLAN_CALL_EVENTS
group by CONVERT(CHAR(8), READ_AT, 112)
order by CONVERT(CHAR(8), READ_AT, 112)