Sergiy--

I appreciate your thoughtful responses to this question and was particularly impressed with your suggestion of a computed column.  Funnily though, no one has answered the question which is "shouldn't...

Noel--

It works with a field, it doesn't work with an expression.  My questions are 1)should it work with an expression?  and 2)why not?

I have convinced myself that it isn't recursive. ...

I wrote an embedded query very much like the one shown.  I was expecting someone to identify whether or not it is possible to group by an expression and use that...

The package does not fail--it executes. Only the task that pulls data from the SQLAnywhere db fails. There are no errors reported...

Brendon--

I have some experience with Sybase SQLAnywhere 5.0. On that platform you use 'Sybase Central' and 'ISQL' which are analogous to 'Enterprise Manager' and 'Query Analyzer'.

I have found the...

Thanks mromm--

I will need to call this chunk of code in several contexts, I was hoping to just use it as a view for ease of use (change once, call...

Thanks Mark,

I am writting a simple MS Access application that will allow a clerk to manually call the DTS routine (pull data from legacy system to SQL server). Ideally I...