Archive for November, 2007
Pass multiple strings to stored procedure IN statement using XML
November 5th, 2007(Revised 3.18.08)
Let’s say you have a listbox with multiple items selected, like this:And let’s say that you want to take the selected items and send them to a stored procedure to run in an IN statement in the WHERE clause, like this: SELECT * FROM tblProjects WHERE ProjectCity IN (‘Lewiston’, ‘Portland’, ‘Spokane’)
Turns out it’s not [...]