get single record from comma separated values

See more:

SQL-Server

table

Hi all,

i am passing comma separated values to my stored procedure. something like below:

@id=1,2,3,4
@firstname='a','b','c','d'

now if i write select statement then i want single data from @id and @firstname. something like below:

id firstname
1 a
2 b
3 c
4 d


thanks