how to process comma separated values
===

How to load a comma separated values into a table in one single select statement?
I have to write a stored procedure where in it takes comma separated values as parameters and loads that into to table.
SQL Server 2008
thank you,
Smith
