[RESOLVED] SQL Stored procedures in VB & ADO

[nvierros]

Hey guys,

Wondering if someone could help me out

basically i have..

rs.open "SELECT customerid, custfname, datefrom, dateto, delstats, status FROM Invoices WHERE datefrom='" & getdate & "' And not status= 'Cancelled' order by customerid", con, adOpenKeyset, adLockReadOnly

Now, how could i convert that to a stored procedure in MS SQL and then execute that procedure from VB using ADO?

Help greatly appreciated