April 14, 2011

To Get records from another database on same server

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