Skip to content

Instantly share code, notes, and snippets.

View trullock's full-sized avatar

Andrew Bullock trullock

View GitHub Profile
set transaction isolation level read uncommitted
select
c.[Id],
c.[Name],
c.[SentOn],
count(s.Id) as sent,
sum(cast(s.[Bounced] as int)) as bounced,
sum(cast(s.[Complained] as int)) as complained,
sum(cast(s.[Opened] as int)) as opened,