TI interactivity with SQL Server

[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

[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.

[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.