I need to write a stored procedure that can receive a variable number of parameters from 1 to 100 (all character.) I really don't want to create 100 arguments, nor do I want them to one parameter string containing and I have to parse the values out. I really would like to receive the values in a dynamic array parameter, but I haven't seen any examples of this in SQL Server. What do you see as a good solution for my problem.