Hi!
I tried to find such information but without a success, so I decided to post my question - is there any correspondence between Column-generated SQL query and User-defined SQL query. In particular if I've got defined both of them in the same stage, which one is executed or if both - in which order?
normaly the one you select is excecuted. If you make a column-based one the statement is basis for change in user-defined. Sometimes you have some strange behaviours. If you switch from user-defined to column best is to delete the user defined one. If you use user-defined best is also to delete derivations in the column-definition completly otherwise you may also get strang or wrong behaviour.
Yup. And I personally haven't seen any need to delete one or the other when switching. The only thing that it tends to confuse or cause strange behaviour in that I've noticed is the person looking at the job.
-craig
"You can never have too many knives" -- Logan Nine Fingers
I have seen instances where the generated and custom SQL statements used different job parameters, and when running the job, you still had to supply values for both.