waheed71 (1/6/2014)
Dear Chris,Thank you. Can you please give me example of below text.
Change the join column on my query to whichever MAX column fits your requirement.
Sure.
Change this:
INNER JOIN ST_SUPPLIER su
ON su.SU_SUPPLIERCODE_P = d.PH_SUPPLIERCODE
to this:
INNER JOIN ST_SUPPLIER su
ON su.SU_SUPPLIERCODE_P = d.LASTVENDOR
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden