-
Hi new user here. But don't hold that against me.
I need a little help. I am using VB5 attaching to SQL Server 6.5, I have created a stored procedure which outputs to a temp table. what I want to do is....
Execute the stored procedure from within my vb code but before the temp table is dropped populate a recordset so that i can use the information returned by the Stored Proc.
Any Help would be greatly appreciated.
Thanks
Inferno!
-
Do you need to create a temporary table at all?
Why don't you just fire off a stored procedure to return a record set?
-
I think thats what i am going to do now.
I spotted that method on one of the other posts, haven't had chance to implement it yet though.
Thanks for the reply.