hi..thanks for the code reference.  One more question, what if the query is long.  Can it still be set to a variable then called within the routine.    I can try to test that too.  I just wondered if you had executed a long query within a routine.



Thanks so much for the help.  I am able to access the Task Manager.  Question, can an SQL query be set up via the Task manager wizard so that it will execute?


Hi There,

What I meant by filter is similar to the filters in Excel where a sort can be specified as an example.   In my routines, I take a delimited file and then can manipulate the logic based on the request.  The file can be created in Excel format.  Is this what you mean that you take files for use in Excel?


Alicia has no followers yet.
Global Masters badges:
Alicia has no Global Masters badges yet.