• I think you should use Table Valued Parameter. The below link has examples in it too.

    http://blog.sqlauthority.com/2008/08/31/sql-server-table-valued-parameters-in-sql-server-2008/