Using SQL Except to Query Part Routings in MAX
The other day I had a customer ask me for a query that would find Part Routing records the did not include a specific workcenter. I provided this snippet to help. This query selects the set that includes both(or all depending) work centers then “excepts” or removes the ones that contain “Work Center A”. USE…