Skip to Content
0
Former Member
Jun 19, 2009 at 05:36 PM

DESKI Report using Temp tables in MS- SQL server 2005

32 Views

Hi,

I am trying to create a Free hand SQL DESKI report using temp tables in MS SQL Server-2005, I am using ODBC connection.

When I run the report, I am getting the error

u201CConnection or SQL sentence error (DA0005) No column or data to fetchu201D

Ex:

Select *

into #t1

from region

select * from #t1

drop table #t1

Please help.

Regards,

Pratik