I have a database with tables and subtables in a one to many relationship for SQL 2000. When adding each record in the main table I will also have to add multiple records to the subtable. The number of records added to the subtable is a variable length based on data recieved from the user interface. What is the best way to insert these rows of data to the subtable using a stored procedure? I don't want to loop through the input data in the component b/c I will be calling the same stored procedure multiple times which is costly. Currently, I am passing a semicolon delimited string to the Stored Procedure which is then parsing and inserting the data into the subtable inside of a while loop. Is this the best approach for this problem?? I also can't user ForXML (which can do this easily I guess) because it is forbidden by my company. Thanks for your help!!!!!