Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.
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
|SQL Select Query help||3||31|
|Why its difficult to Insert the Bit and date time value in sql Database||7||30|
|How to delete duplicate records within a SQL Server 2008 table using a SQL statement?||5||16|
|SQL Server Error Log - logging period||1||20|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
18 Experts available now in Live!