Received table from Dave Briar
- Loaded
- Created views
- Created a view to do a join as a match
- Created a translate table
insert into nwis_translate_usgs_parm_list_units
(odm_unitAbbreviation,usgs_parm_unt_tx)
SELECT DISTINCT UnitAbbreviation, parm_unt_tx
FROM v_usgsParamWithUnits
ORDER BY UnitAbbreviation, parm_unt_tx
go
update nwis_translate_usgs_parm_list_units
set matchby ='Join with units',
matchDate = getdate()
where odm_unitAbbreviation is not null