329
edits
Changes
Jump to navigation
Jump to search
create view ...DROP VIEW IF EXISTS june_2017_zipcode_hotfix;CREATE VIEW june_2017_zipcode_hotfix AS SELECT reelno, frameno, name, GodHelpUsAll(postcode_cleaned, postcode) as postcode FROM ptoassigneend_us_cleaned;</nowiki>
→A Stopgap Measure
== A Stopgap Measure ==
As a quick and dirty fix, walk through the cases and do the best we can. The script for that is located at <code>E:\McNair\Projects\SimplerPatentData\src\db\ZipCodeHotfix.sql</code> and it creates the following table:
<nowiki>
