SQL :
Create Table #Temp
(ID int IDENTITY(1,1) Primary Key,Date_ Date)
--Insert Into #Temp (date_) Values
--('20150101'),('20150105'),('20150131'),
--('20150210'),('20150214'),('20150225'),
--('20150310'),('20150314'),('20150325'),
--('20150410'),('20150414'),('20150425'),
--('20150510'),('20150514'),('20150525'),
--('20150610'),('20150614'),('20150625'),
--('20150710'),('20150714'),('20150725'),
--('20150810'),('20150814'),('20150825'),
--('20150910'),('20150914'),('20150925'),
--('20151010'),('20151014'),('20151025'),
--('20151110'),('20151114'),('20151125'),
--('20151210'),('20151214'),('20151225'),
--('20160210'),('20160214'),('20160225')
Select * from #temp where MONTH(date_)=4
Select * from #temp where Year(date_)=2016
Select * from #temp where MONTH(date_) = MONTH(GETDATE())
Select * from #temp where Year(date_) = YEAR(GETDATE())
There are 4 query :
Query 1 will show you the details of month 4(April).
Query 2 will show you the details of Year 2016.
Query 3 will show you the details of Current Month.
Query 4 will show you the details of Current Year.
Hope this might Help!
