Comma Separated Lists in Parameters : SQLServer

I have a ton of stored procedures that have multiple parameters where the values provided are comma separated lists. The best example is a…