Actually u can sort of use a single parameter to insert multiple values but is tricky. Using TVC or in 2005 SQL versions and below "http://www.sommarskog.se/arrays-in-sql-2005.html" or you can use at trick with "Like"