The Tech Pursuit
The Dev Shelf
Pages
Home
Interview Questions
About Me
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment