Can anyone advise how best to get a recordset back from a stored procedure using VBScript?
I need to pass a stock code as an input parameter and I'd like to get a recordset that I can then iterate over and process in my vbscript.
I want to pass the start of the stock code to the stored procedure (e.g. B1%) and get a list back.
My test stored procedure looks like this.
ALTER PROCEDURE [dbo].[ALtest]
-- Add the parameters for the stored procedure here
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
SELECT StockCode, Description from InvMaster where StockCode like @p_StockCode