Does anyone have a clue as to how to execute a query or stored procedure on the server in ASP code with createobject() (instead of plugging select statement in the source property)?

I've heard that running the query or stored proc is faster, but I can't get it to work!!!