SQL Server with Mr. Denny:

OPENXML

1

November 30, 2009  11:00 AM

OPENXML can be a beast sometimes.



Posted by: Denny Cherry
OPENXML, Performance Problems, SQL, Table Variables

Our application includes some search functionality which is pretty complex to deal with.  In a nutshell the user can select multiple values from a couple of lists on the website and use those listed to filter down the rows which are being searched.  These lists are passed into the SQL Server as a...