I have a scenario where I will be getting search results from a front end UI. If nothing is passed I should return all results, but if the users have selected one to many choices I will need to filter based on those choices. My delima is how
to handle this approach. The data will be coming in the form of XML and I will need to shred it to get the criteria.
I was thinking I could use "WHERE EXISTS" Clauses and if there are any results passed to me I could fill a table variable with everything and join to it.....if they did make selections then I could fill the table with just those choices.
I really just don't like the idea of having to fill the table with everythign when nothing is selected.
Just wondering what others have done to handle this type of scenario?
View Complete Post