Can I use variables sent into a stored procedure as INSERT values within a multiple record append query? <BR><BR>I&#039;m using the ROWCOUNT (as Dutch suggested) to limit the number of records brought back from user submitted criteria. Along with these specific records I also need to add variables inserted into the same table that I send in from the ASP page.<BR><BR>Any ideas?<BR><BR>CREATE PROCEDURE sp_addtocartbronze<BR>(<BR> @stramount int,<BR> @strstate nvarchar (2),<BR> @strcustomerid nvarchar (50),<BR> @strterm int<BR> <BR>)<BR>AS<BR><BR>SET ROWCOUNT @stramount<BR> <BR>INSERT INTO [shoppingcart] (id, email, state, amount, term) SELECT (????)<BR><BR>Could I use a select into statement before this to bring records into a temporary table? If so how would I get my variables in there as well? <BR><BR>Thanks for your help!<BR><BR>