Warning: This solution only works with SQL Server 2008 Step 1. Create a Table Type The Table type will hold the values from your multi-value parameters list. Code Example: CREATE TYPE [dbo].[CustomerTableType] AS TABLE( [PARAM] [int] NULL, [RunningId] [int] IDENTITY(1,1) NOT NULL, CHECK (([RunningId]<(10000))) ) Note: if you want a generic table type you can change the name to IntTableType, GUIDTableType, or VarcharTableType or whatever makes s... [More]