InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 10:47:54 GMT20http://www.sqlservercentral.com/Forums/Topic1398031-8-1.aspx[quote][b]mozturk 92000 (12/20/2012)[/b][hr]T-SQL : Select * from Gecoserv where typeOfEcosystem IN (:typeNameList) AND service IN (:serviceNameList)[/quote]That is the same thing you posted originally. It seems you want some help with the code. I am willing to help but you have to provide me with something to work with. ddl, sample data and desired output. As I said before you find details about best practices for posting questions by clicking the first link in my signature. I am certain that if you post the necessary information you will have an answer very quickly.Fri, 21 Dec 2012 07:45:42 GMTSean Langehttp://www.sqlservercentral.com/Forums/Topic1398031-8-1.aspxT-SQL : Select * from Gecoserv where typeOfEcosystem IN (:typeNameList) AND service IN (:serviceNameList)Thu, 20 Dec 2012 08:42:23 GMTmozturk 92000http://www.sqlservercentral.com/Forums/Topic1398031-8-1.aspx[quote][b]mozturk 92000 (12/18/2012)[/b][hr] (It's HQL which is similar to T-SQL)How can I fix my problem ?[/quote]Write it as a stored procedure in T-SQL instead of relying on HQL. ;-)Tue, 18 Dec 2012 23:10:11 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic1398031-8-1.aspxHi and welcome to SSC. It is pretty difficult to provide a detailed answer for your question without speculating quite a few things. You might want to take a quick look at the first link in my signature for best practices when posting questions.Tue, 18 Dec 2012 13:57:04 GMTSean Langehttp://www.sqlservercentral.com/Forums/Topic1398031-8-1.aspxI would like to explain my problem with a simple example.Here is a part of my database:Type Service----- -----Freshwater HabitatSaltwater FoodDunes RecreationThat's the query I have: (It's HQL which is similar to T-SQL)from Gecoserv _a where _a.typeOfEcosystem IN (:typeNameList) AND _a.service IN (:serviceNameList)I want the grid to show only the single combinations (Freshwater-Habitat, Saltwater-Food and Dunes-Recreation etc.) but it shows also other combinations (ex: Freshwater-Recreation).How can I fix my problem ?Tue, 18 Dec 2012 13:51:11 GMTmozturk 92000