Multiple Sql Statement Not Returning A Datatable

Question

Dear Code Masters I believe all of you are doing fine i have a SQL challenge kindly view the image below what i want to achieve is the SQL statement that will use  Select  Statement to read the table for State LGA Facility Name Month1 Month2 Year Range Year1 to Year2 and Thematic Area . i have tried the following statement  Select * from VW_ART WHERE states='Enugu' and lga ='Udi' and Facname ='Udi Districts Hospital' AND years = '2015' OR (years= '2016' and months IN ('January'  'December'))  Which is not returning any records and the records are present but when i make the Year 2016 both it work Then if i state Months say from April to May 2016 for both  i expect two months it will display all the records in the data base. Kindly assist me with thanks

Vignesh Mani · Answer

If Need only which you have slected maonth Select * from VW_ART WHERE states='Enugu' and lga ='Udi' and Facname ='Udi Districts Hospital' AND years between '2015' and '2016' and months IN ('January'  'December')) If you need between From to To month using month id. Select * from VW_ART WHERE states='Enugu' and lga ='Udi' and Facname ='Udi Districts Hospital' AND years between '2015' and '2016' and months BETween 1 and 5

Bikesh Srivastava · Answer

need to correction in query see below. Select * from VW_ART WHERE states= 'Enugu' and lga = 'Udi' and Facname = 'Udi Districts Hospital' AND (years = '2015' OR years= '2016' ) and months IN ( 'January'  'December' ) it will be working fine.

Abraham Olatubosun · Answer

Many thanks to Midhun TP and Vignesh Mani for all your tips and solution but my question again Mdhun is what if i want data from 2015 to 2016 between April and May or between Jan Feb March April what will happen then. thank you for all the solution tips

Midhun T P · Answer

Hi If you need data for year 2015 as well as 2016(only January and december) then you can try below query - Select * from VW_ART WHERE states='Enugu' and lga ='Udi' and Facname ='Udi Districts Hospital' AND (years = '2015' OR (years= '2016' and months IN ('January'  'December')))

Abraham Olatubosun · Answer

Dear Code Masters and Vignesh Mani thank you for all the suggestions and tips they truely help. However Vignesh the months are all strings i thought i can use them as strings except if you want me to change all the web forms where i use months to convert to int's that is using DropdownListBox.SelectIndex. Any help please Thank you.