Multiple Sql Statement Not Returning A Datatable

Abraham Olatubosun

9y1.1kSQL

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

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vignesh Mani9y ago
Accepted 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
+1
Bikesh Srivastava9y ago
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.
0
Abraham Olatubosun9y ago
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
0
Midhun Tp9y ago
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')))
0
Abraham Olatubosun9y ago
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.
0