>>>Hi
>>>
>>>In ASP many years ago if I had an SQL query where I had multiple parameters not all of which may be filled in I created the SQL in code.
>>>
>>>In the same situation in ASP .NET what are my options. I don't seem to be able to find anything where I may have a flexible number of query parameters. Am I still having to build up my query in code.
>>>
>>>Any thoughts / examples.
>>>
>>>Thanks
>>
>>Can you pass in an XML string as a parm, convert it to a temporary table, and do an INNER JOIN? Kevin G. was an expert on this subject - maybe check his blog?
>
>Cheers Mike.
>
>What address was Kevins blog ?
>
>I'll take a look though that seems like a bit of work for a common requirement.
>
>Nick

If we are thinking the same thing, it's not really that much work after you get it figured out the first time.

www.commongroundsolutions.net - click on the blog link.