We have table-valued parameters since 2008 version.

http://technet.microsoft.com/en-us/library/bb510489(v=sql.105).aspx

I would suggest to start from here and just reach to other approaches if you are not able to leverage it.