title: Passing multiple filtering parameters to a stored Proc
body: <p>I am sure the title of my question doesn't make much sense. But here is what I'm trying to achieve. I have table with different stories(columns are StoryID, StoryTitle, StoryDesc, StoryCategory), so each story can belong to a category. for example category1, category2,.... category10.  I am in the need of a SP, where i specify the categories as parameters(multiple categories, in CSV format or XML) and the SP will return the stories belong to that categories. </p>
  
  <p>I'm not sure what would be the best way to do this in one SP call. Any pointers will be appreciated.</p>
  
  <p>thank you</p>