Hi Team, I want to automate one of my SQL project and need help for same. I’m inserting a data in my dimension table on production server from our reference server based on any new row found in reference table. I’d like implement following things to get it automate ..
INSERT INTO PROD_DB.[dbo].[DimAccount]
Select * from Ref01.REF_DB.[dbo].[DimAccount] D1 left join PROD_DB.[dbo].[DimAccount] D2 on D1.ID=D2.ID where ID is null
Create a job that should run Bi weekly to run update query by itself and produce such results in pdf or excel.