This may sound like a dumb question but where do I write this query? there seems to be no place in the linked server options to run queries. I...

Micheal:

Your way is the same as Antares686's way. IT runs way to slow. 7 minutes and returns no records. SubQueries run crap ass slow in unidata sql along...

I really hate to bust your bubble but your looking at the wrong documentation :] The documentation we need is is Unidata SQL 5.2.

Link to documentation: http://www.informix.com/answers/english/docs/52unidata/Sqlu.pdf

For...

I gave that a shot and well it runs like crap. still returns nothing after 7 minutes. Something tells me that the unioledb provider does not like subqueries...

Thanks for all your guys help but none of it works. I looked into all your ideas but I can't use cursors there is no set command for rowcount...

hmm that won't work well because first of all there is no tsql functionality and secondly I would just return all the rows before creating a temp table thats just...