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.
Table 1 is actually called RNDC IN Pricing All so I believe the reference is correct. Let me know if anything else in the code is incorrect.
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.