Erik Porter's BlogLife and Development at Microsoft and Other Technology DiscussionsSQL WHERE List Matches Any or All- March 26, 2007 I saw a cool post recently from Jon Galloway called "Passing lists to SQL Server 2005 with XML Parameters". This is a pattern I&39;ve used several times while building the new version of Channel 9. If you&39;d like to learn how to pass in lists to stored procedures, check out Jon&39;s post.One of the times I&39;ve used it is to search our database for all entries from two of our forums. For this example, we&39;ll say Techoff and Sandbox. Once you have a...http://weblogs.asp.net/eporter/archive/2007/03/25/sql-where-list-matches-any-or-all.aspx |