delete from ReportFreeDetail where (flngReportFreeID = 3) delete from ReportFreeProperty where (flngReportFreeID = 3) insert ReportFreeProperty select * FROM uf_ndj_999..ReportFreeProperty WHERE (flngReportFreeID = 3) insert ReportFreeDetail select * FROM uf_ndj_999..ReportFreeDetail WHERE (flngReportFreeID = 3)