April 21, 2010

How to access details from another database table

SELECT Keyword,COUNT(*) AS 'Total SMS' FROM SMSPull.dbo.Received_Data
WHERE
MONTH(GETDATE())-1 = MONTH(RecDateTime)
AND
YEAR(GETDATE()) = YEAR(RecDateTime)
GROUP BY Keyword

No comments:

Post a Comment