SQL to pull county, State, Zip from Vertex - Thinkapace Consulting – Transforming Businesses with ERP

SQL to pull county, State, Zip from Vertex

SQL to pull county, State, Zip from Vertex

SELECT  country_code
       ,geography_element22 state
       ,geography_element33 county
       ,geography_element44 city
       ,geography_name zip
FROM    hz_geographies gwo
WHERE   geography_type = 'POSTAL_CODE'
AND     country_code = 'US'
AND     length (geography_element2) = 2
ORDER BY 1,2,3,4,5

Person Change Causes Life Event-Trigger a LifeEvent Based on Number of Hours

SQL to pull Position Costing Information

Leave a Reply Cancel reply