Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.
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.
|SQL Query (lookup)||8||65|
|I need to "lookback" and pull all data from 5pm and prior based on a date time field. Is there a getdatetime funcion?||4||30|
|Restoring .bak and .trn files created by an unknown version of Microsoft SQL Server||7||48|
|Sql does not recognize null value from Oracle source||8||26|
Join the community of 500,000 technology professionals and ask your questions.