I have some code that works fine in SQL Query Analyzer, but fails with an error when running as a job. Here's the code: USE STXbaxt -- Count number...
As a follow-up to this, I'm starting to realise that it's the Informix ODBC driver that can't handle the "?" in the SQL statement. Are global...
I've created a DTS package that reads order information from InformixSE 7.21 tables into lovely customised tables in SQL Server 2000. Thatworks...
Ha ha! No, I didn't! What a dummy! Thank you so much for pointing out the obvious..........which now explains why another one I did was OK........I...
I can't find an answer to this anywhere....... I've created a DTS package that extracts data from a table and exports it to Excel and then emails...
Many thanks FrankKalis for your help. It is very much appreciated. I have gone away and read about dynamic queries and re-written the code to use...
By the way, I know I can do this with 10 SELECT statements, but I wanted something a little more elegant...........
I apologise if this is ludicrously easy, but I've searched for the answer and not found it. Without exactly why I want to do this, I just want to...
Separate names with a comma.
