I can connect to an SQL server using ADO but I am new to writing SQL stored procedures. I have read some good info on sp's on this site but I can't seem to tie the two together.

I open the connection and then I want to pass an input parameter to the stored procedure. I want the stored procedure to run the query and then return results.

What I can't seem to grasp is what I need to do in VB and the sp.

If someone had a really basic example showing code in VB and then the code in the SQL stored procedure I would be much abligged (reckon you haven't heard that kind-a talk in a while).