Skip to content

Instantly share code, notes, and snippets.

@kwestground

kwestground/CompareB1UserQueries.sql

Created December 9, 2019 21:47
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 kwestground/b410ca9ff4f48e74d39609d5cf14d546 to your computer and use it in GitHub Desktop.
Save kwestground/b410ca9ff4f48e74d39609d5cf14d546 to your computer and use it in GitHub Desktop.
Download ZIP
Compare User Queries between two SAP Business One Databases
Raw
CompareB1UserQueries.sql
SELECT S."QName", S."QString", ST."QName", ST."QString",
CASE WHEN CAST(S."QString" AS varchar) <> CAST(ST."QString" AS varchar) THEN 1 ELSE 0 END AS "Diff"
FROM "OUQR" S
LEFT JOIN "DB2"."OUQR" ST ON S."QName" = REPLACE(ST."QName", '-', '-')
WHERE S."QName" LIKE '%'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment