<< So based upon what I am hearing back... no moving visual feed back to a user during such a PROJECT command is currently available? (Cursors are not an option here) >> Well, there's always a solution to everything. . .
If you really, really, really need the feedback you can use a stored procedure. Include the stored procedure in your PROJECT, either on a spare column or on some other column. In the Stored Procedure code update your UI (a progress bar, or whatever). If the SP is projected into a spare column it doesn't need to take params or return a value. If it's projected into a real column, it needs to accept the column data as an argument and return the same value unchanged as the return value. This will slow down your PROJECT considerably, but it will do what you want. An alternative would be to ask for an enhancement to all SQL command called WITH MESSAGE that will periodically update the UI, or a setting to do the same thing. -- Larry
