1.i need to Write a SP to accept comma separated values and return as list of string values
If you're on SQL 2008 or above then why would you ever want to do that when you can use a Table-Valued Parameter?
Table-Valued Parameters (Database Engine) - SQL Server 2008
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato