Hi Eric,

Is the below query work, if StoreOpsArchive.SalesHistory table exists in another server.

delete from Sales

output deleted.*

into StoreOpsArchive.SalesHistory

where SaleDate < dateadd( month, -13, SaleDate );

• This reply was modified 3 months, 3 weeks ago by KrantiHYD.

@SQL006 how you resolve this issue

@SQL006 how you resolved the issue. Did you get any solution for this.