you can do trace output directly to table and query the trace data using group by

you are right. I also feels the same

IF FLD1 AND FLD3 is FK IN QALS referring to QAVE and JEST

then I think a simple query like this should yield you the desire result

SELECT QALS.Fld1,QALS.Fld2, QALS.Fld3, QAVE.Fld4, JEST.Fld5,...

If I were you my plan would be something like this; get the randomly selected sample data and see which of the following is more unique (1 - (dup_val/ sample...

not very sure with your table schema, but a query like this is more readable and relatively it would be faster then using sub queries.

update cq set cq.Quantity =...

Florian is absolutely right, use joins perhaps with CTE this will make your code more readably..

The point is not seeing you $$ for value, its management who feels that they saves $$ by outsourcing. If the quality of service was so bad and all the...

This is the way business is happening around the world. Value for $$ is always on the mind of management.

Better not to crib just accept the reality and move...