If you have a sql server stored procedure that returns a recordset (i.e. returns a select statement), here is how you use it in an ASP page:

Dim adoCon         

Set adoCon = Server.CreateObject("ADODB.Connection")

adoCon.Open "Provider=SQLOLEDB.1;Persist Security Info=True;User ID=sa;Password=password;Initial Catalog=Database;Data Source=sqlserver"

Dim rs99

Set rs99 = Server.CreateObject("ADODB.Recordset")

set rs99 = adocon.execute("exec spGetPriceList '" & customerfeed & "'")  

Do while not rs99.eof

Loop

rs99.close

Set rs99=Nothing