Jeff, I agree with you. Having thousands or millions of calls to a procedure like this will be a problem. However stored procedures with multiple parameters are not used widely...

Jeff, This article is about calling a stored procedure with multiple parameters not for retrieving data from a column with values separated by comma. Do you really believe that it...

There is another article from 2008, which covers the same scenario : Multivalue Parameters With SQL SP

It addition of the 2 methods posted here Comma separated text and SQL Server...