@ratbak Just curious if I did follow an ETL in SQL would I import the table, transform it using SQL and then create a new table/s to insert the values...
Yes CPZ and CPZCode have a one to one relationship. Regarding the naming method you suggested, it is good practise and I will implement that in future. Thanks for the...
You're right I should have given more detailed. Below please find attached some more information I've included. Please note, its a struggle getting all the information as I need to...