SELECT cvw_FlatView_Cases.NoticeNumber, cvw_FlatView_Cases.IssueMonthYear FROM SiDem_Reports.dbo.cvw_FlatView_Cases cvw_FlatView_Cases WHERE (cvw_FlatView_Cases.IssueDate>={ts '2012-04-01 00:00:00'} And cvw_FlatView_Cases.IssueDate<=getdate()) GROUP BY cvw_FlatView_Cases.NoticeNumber, cvw_FlatView_Cases.IssueMonthYear
Hey Can you please guide, the above is my SQL and below is the result I am getting. I only want to count the number of HQ% that comes in a month and dont want to see the actual number any help?
SELECT count(*), cvw_FlatView_Cases.IssueMonthYear FROM SiDem_Reports.dbo.cvw_FlatView_Cases cvw_FlatView_Cases WHERE (cvw_FlatView_Cases.IssueDate>={ts '2012-04-01 00:00:00'} And cvw_FlatView_Cases.IssueDate<=getdate()) GROUP BY cvw_FlatView_Cases.IssueMonthYear
========================================== Cursors are useful if you don't know sql. SSIS can be used in a similar way. Beer is not cold and it isn't fizzy.
Month
Posted - 10/24/2012 : 05:55:31
