How to generate Dynamic where condition for single stored procedure and pass from code behind

You can pass the where clause as a parameter to your stored procedure, but that means you'll need to build your query as a string, and use sp_executesql to execute it.

This article has been dead for over six months. Start a new discussion instead.