Dear All,

I have a problem with Temp Table and ADO. I use MSSQL Server 2000 and ADO 2.6 with Visual Basic 6.0

1. --> I Create Stored Procedure as follows


CREATE PROCEDURE sp_GetData()
AS
CREATE TABLE #T1(ItemCode char(15) NOT NULL PRIMARY KEY,
QTY_RSVD bigint,
QTY_AVBL bigint)


-- I INSERT SOME DATA FROM Various Tables to Table #T1


SELECT * FROM #T1

GO

-- END OF STORED PROCEDURE


2. --> Try to open above stored procedure with ADO, IT was not successfull



I need to know Is It possible to get the out put of the stored procedure to a ado recordset?

If it is possible please help me to do It.


Thank you,

Dinesh