populate staging table 2 COV_POD from SBC_POD for standby energov (part 3)

Question

staging table 2 

 

1. TRANSFORM AND COPY DATA FROM SBC_POD TABLE TO COV_POD TABLE

 

 

2. Parse LastName, First Name from OwnName

 

 

 

3. Fix 9 digit Zip Code to be Zip+4, Parse City, State, Zip from OwnCitySt, based on matching values in USStates Table

 

 

4. Fix Street Names