Calling Stored Procedures In ASP

I am trying to use a stored procedure created in SQL Server 2005 and execute it in ASP. How can I return the entire recordset from the stored procedure the way I can do it with a recordset?

set cmd = Server.CreateObject("ADODB.Command")
set cmd.ActiveConnection = Conn

' Specify the name of the stored procedure you wish to call
cmd.CommandText = "sp_Org_Structure"

'Form variable to pass as a paramter to the SP
strUI = 4655

sql = "EXECUTE sp_Org_Structure " & strUI
response.write sql

Secondly, instead of hard-coding the name of the SP in the sql statement, how I call the 'cmd.CommandText' from within this SQL Statement.