Does anyone know if there is a limit to the amount of comparisons that can go in a where clause? Basically, the user can do a search which returns 2500 header records and I need to fetch the child records. I do this in two database calls. So, in my second call, I have a huge where clauses and I get a "please disregard the results" error from sql server. Any clues?

How does the where clause looks like? and how do you build it?

Walaa wrote:

How does the where clause looks like? and how do you build it?

I simply enumerate though a collection and build my predicate. When I tried using the 'IN' clause, i just populated an arraylist and passed this. Note, I think it has to do with ado.net or something, b/c it works fine in query analyzer.

Too many elements. There's a limit on how much parameters can be placed inside an IN() clause or how much parameters can be sent to the server.

Ok thanks! I just ended up created a sproc with a temp table.