SK
.
SHATRUGHNA
KUMAR
ARCHITECTURE / ENGINEERING
Home
Expertise
Insights
About
Let's connect ↗
The Tech Pursuit
The Dev Shelf
Pages
About Me
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment