Skip to content
This repository was archived by the owner on Apr 9, 2025. It is now read-only.

ExceptionHistory

Jump to bottom
Daniel Hazelbaker edited this page Mar 22, 2015 · 1 revision 
SELECT DATENAME(YEAR, ex.exception_date) + '-' + RIGHT('0' + CAST(MONTH(ex.exception_date) AS NVARCHAR(2)), 2) + '-' + RIGHT('0' + CAST(DAY(ex.exception_date) AS VARCHAR(2)), 2) AS 'Date',COUNT(*) AS 'Count'
   FROM core_exception AS ex
   WHERE DATEADD(DAY, -30, GETDATE()) < ex.exception_date
   GROUP BY DATENAME(YEAR, ex.exception_date) + '-' + RIGHT('0' + CAST(MONTH(ex.exception_date) AS NVARCHAR(2)), 2) + '-' + RIGHT('0' + CAST(DAY(ex.exception_date) AS VARCHAR(2)), 2)
   ORDER BY 'Date'

Clone this wiki locally