Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.
SELECT MONTH(MD.DateAdded) AS 'MonthSent', MD.AccountID, A.Organisation, COUNT(MD.MessageDataID) AS 'Messages Sent' FROM TA_BUSINESS.dbo.tbl_MESSAGES_DATA AS MD WITH (NOLOCK) LEFT JOIN TA_BUSINESS.dbo.tbl_ACCOUNTS AS A WITH (NOLOCK) ON MD.AccountID = A.AccountID WHERE (MONTH(MD.DateAdded) BETWEEN 1 AND 3) AND YEAR(MD.DateAdded) = 2014 AND (MD.MessageTypeID = 1 OR MD.MessageTypeID = 4 OR MD.MessageTypeID = 5) AND MD.IsMessageIncoming = 0 AND A.ResellerID = 2007 GROUP BY MD.AccountID, A.Organisation, MONTH(MD.DateAdded) ORDER BY MD.AccountID
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.