Page 1 of 1
TI interactivity with SQL Server
Posted: Tue Jul 21, 2009 8:21 pm
by jshurak
I have a T SQL query that creates a temp table and references it later in a join statement. Does anyone have experience running anything like this in TI? The query fails when run in TI. Thanks
Re: TI interactivity with SQL Server
Posted: Tue Jul 21, 2009 8:30 pm
by George Regateiro
TI should be able to do anything that any other ODBC client can do, since all it does is pass off the query to the selected driver. Have you tested the SQL in something outside of SQL servers management studio? The Excel MS Query route is a quick and dirty one.
Re: TI interactivity with SQL Server
Posted: Wed Jul 22, 2009 12:17 pm
by David Usherwood
How 'temp' is your temp table? From memory, if it is (eg) #temp1 then it will be dropped after the script is done, and you are probably running an odbcoutput to build it and a TI to read the results. Try ##temp1 which should stay around between scripts. You'll need to clean up afterwards/check for existence first.