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)
            

Drop foreign key constraints and recreate them