Forum Discussion
Solved
Nearest value from another table with lookup criteria
I have two tables: Table 1 is pricing information with columns Pricing Group and Deal Price Table 2 is sales information with columns Pricing Group and Sales Price I'm trying to figure out the ...
But where is the query step that defines #RUNDC?
You are using it as previous step. PQ evaluates every step.
Try removing the #rundc.
It should work.
I am seeing any problem.
If my assistance helped you in any way, hit 👍
accept it as a solution.
I got it to work but it takes forever to run especially with 10K+ lines of data. Thank you for your help.
Happy to help.
Appreciate the kudos. 👍