INSERT INTO [PRODSERVER1].[PRODDB1].[dbo].[TABLE1](
...
          )
SELECT DISTINCT ....
from [PRODSERVER1].[PRODDB1].[dbo].[TABLE2] ev with(nolock)
left join [PRODSERVER1].[PRODDB1].[dbo].[TABLE3] an with(nolock) on ...
left join [PRODSERVER1].[PRODDB1].[dbo].[TABLE4] ics with(nolock) on ....
left join [PRODSERVER1].[PRODDB1].[dbo].[TABLE5] sh on ....
left join [PRODSERVER1].[PRODDB1].[dbo].[TABLE6] ile with(nolock) on ...


delete from [PRODSERVER1].[PRODDB1].[dbo].[TABLE8] where [Дата]>=...
INSERT INTO [PRODSERVER1].[PRODDB1].[dbo].[TABLE8]
(...)
SELECT ....
FROM [PRODSERVER2].[PRODDB2].[dbo].[TABLE9] t1
left join [PRODSERVER3].[PRODDB3].[dbo].[TABLE7] t2
 on ....
where [Дата]>=...