Skip to content

Instantly share code, notes, and snippets.

@chadsten

chadsten/mismatch.sql

Created November 29, 2018 21:03
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save chadsten/de390b6bd0697b8bc51bf34ebad2d128 to your computer and use it in GitHub Desktop.
Save chadsten/de390b6bd0697b8bc51bf34ebad2d128 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
mismatch.sql
SELECT OD.PartNum AS OPN, QD.PartNum AS QPN, OD.OrderNum, OD.OrderLine, OD.QuoteNum, OD.QuoteLine
FROM Epicor10.erp.OrderHed AS OH
LEFT JOIN Epicor10.erp.OrderDtl AS OD ON OD.OrderNum = OH.OrderNum
RIGHT JOIN Epicor10.erp.QuoteDtl AS QD ON OD.QuoteNum = QD.QuoteNum AND OD.QuoteLine = QD.QuoteLine AND
SUBSTRING(OD.PartNum, PATINDEX('%[^0]%', OD.PartNum+'.'), LEN(OD.PartNum)) <> SUBSTRING(QD.PartNum, PATINDEX('%[^0]%', QD.PartNum+'.'), LEN(QD.PartNum))
WHERE OH.OrderDate > DATEADD(month, -24, GETDATE())
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment