Hope somebody could possibly help here? Im no SQL Expert and pulling my hair out trying to find an answer!
We have a SQL Database which has a Link Database to Google BigQuery. On the SQL Server I can run the following query which returns all the data.
SELECT * FROM OPENQUERY([BQ], 'SELECT * FROM dataviews.salesdata')
What I would like to be able to do is import all this data into a table in our SQL Database called SalesData.
I only want to insert the fields that have changed though (or don't exist).
Could somebody possibly help me with a SQL Statement
Thanks in advanced for any Help offered!