"Jorge Lozano" wrote:

> Hi ,
>
> I've created a stored procedure wich creates a temporal table (called
> #results) , then i fill the table with data and finally at the end of the
> procedure i make a "Select * FROM #Results" .
>
> When i execute the procedure from the query analizer  i can  get the data
> without any problem. But if i try to get the data into a visual basic ADO
> recordset it always fails. I think the problem is because i'm using a
> temporal table , but i need to use that solution.
>
> If someone could give me one solution to get the data of a temporal table
> into a recordset i'd been thankful.
>
> Thanks in advance for you answers and pardon for my bad english.

"Jorge Lozano" <JorgeLoz***@discussions.microsoft.com> wrote in message
news:FED3495C-D379-457D-AE02-D9B188B156BC@microsoft.com...
> Hi ,
>
> I've created a stored procedure wich creates a temporal table (called
> #results) , then i fill the table with data and finally at the end of the
> procedure i make a "Select * FROM #Results" .
>
> When i execute the procedure from the query analizer  i can  get the data
> without any problem. But if i try to get the data into a visual basic ADO
> recordset it always fails. I think the problem is because i'm using a
> temporal table , but i need to use that solution.
>
> If someone could give me one solution to get the data of a temporal table
> into a recordset i'd been thankful.
>
> Thanks in advance for you answers and pardon for my bad english.

"Tibor Karaszi" wrote:

> My guess is that it will work if you add SET NOCOUNT ON in the beginning of your stored procedure.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
>
> "Jorge Lozano" <JorgeLoz***@discussions.microsoft.com> wrote in message
> news:FED3495C-D379-457D-AE02-D9B188B156BC@microsoft.com...
> > Hi ,
> >
> > I've created a stored procedure wich creates a temporal table (called
> > #results) , then i fill the table with data and finally at the end of the
> > procedure i make a "Select * FROM #Results" .
> >
> > When i execute the procedure from the query analizer  i can  get the data
> > without any problem. But if i try to get the data into a visual basic ADO
> > recordset it always fails. I think the problem is because i'm using a
> > temporal table , but i need to use that solution.
> >
> > If someone could give me one solution to get the data of a temporal table
> > into a recordset i'd been thankful.
> >
> > Thanks in advance for you answers and pardon for my bad english.
>
>

"Jorge Lozano" <JorgeLoz***@discussions.microsoft.com> wrote in message
news:02F4D367-6A89-49C9-9971-BE5BA4927491@microsoft.com...
> It worked Perfect!!!
>
> Thanks a loot Tibor i owe you a very big beer.
>
> "Tibor Karaszi" wrote:
>
>> My guess is that it will work if you add SET NOCOUNT ON in the beginning of your stored
>> procedure.
>>
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>>
>> "Jorge Lozano" <JorgeLoz***@discussions.microsoft.com> wrote in message
>> news:FED3495C-D379-457D-AE02-D9B188B156BC@microsoft.com...
>> > Hi ,
>> >
>> > I've created a stored procedure wich creates a temporal table (called
>> > #results) , then i fill the table with data and finally at the end of the
>> > procedure i make a "Select * FROM #Results" .
>> >
>> > When i execute the procedure from the query analizer  i can  get the data
>> > without any problem. But if i try to get the data into a visual basic ADO
>> > recordset it always fails. I think the problem is because i'm using a
>> > temporal table , but i need to use that solution.
>> >
>> > If someone could give me one solution to get the data of a temporal table
>> > into a recordset i'd been thankful.
>> >
>> > Thanks in advance for you answers and pardon for my bad english.
>>
>>