In this line of code: INSERT INTO scada_archive.dbo.ScadaArchive SELECT * FROM #tagData WHERE DateAndTime < @sd;

you filter on DateAndTime... just filtering your remote table on that will return fewer...