<% set oConn = Server.CreateObject("ADODB.Connection") siteid=2 strParms=siteid & ",' '" oConn.Open strConn Set rsjobs=Server.CreateObject("ADODB.Recordset") Set rsjobs=oConn.Execute("exec sp_test" & strParms)%> <%=rsjobs("id") %>