Hello everyone. I am a newbie to SQL development. I need your help to understand whether what I am about to do is feasible.
I have de-normalized data in csv files from different tables. I want to normalize the data and import them into tables in production database. Some of the records are many to many and also auto incremented keys that joined them together. The data, because they are not brand new, they are linked to existing records in the database.
As you can see from the attached file, the InterestID is from Interest Table, ContactID from contacted from comtact table etc but, the output was derived as a result of join queries. Again, the Landreference is one to many relationship to Interest and Contacts. So, field was transposed into column like this, 24,602,452,354,010,700. This would need to un-pivot and linked them back to contacts or Interest tables.
These arethe tables joined together for the csv output.
FROM dbo.tbl_Land
JOIN dbo.tbl_Land_Address
JOIN dbo.tbl_Address
JOIN dbo.tbl_Interest
JOIN dbo.tbl_Nature AS
JOIN dbo.tbl_Nature_Type
Can someone please advise if this is technically doable. Please see the sample data below.
Thanking you for your time and advise.
Rac