SK
.
SHATRUGHNA
KUMAR
ARCHITECTURE / ENGINEERING
Home
Expertise
Insights
About
Let's connect ↗
The Tech Pursuit
The Dev Shelf
Pages
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