By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,779 Members | 1,101 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,779 IT Pros & Developers. It's quick & easy.

Search table with any one or more fields using static sql

P: 1
Hi,
We are looking for static sql query for the below requirement
we have 15 fields on front end and user can search the table by providing any number of fields out of 15.
as we dont know the exact criteria the number possibilities may become 15! (15 factorial) for each possibility we need to write a query but this is vast process..
Alternative to this is we can use dynamic sql or sql with COALESE can be used to fix this but performance wise this two possibilities are not accepted. so can have other possibility.

Thanks
Oct 3 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.