- Increase transparency
- Onboard new hires faster
- Access from mobile/offline
CREATE PROCEDURE FINAL_BATCH_INS AS DECLARE @BatchSize INT = 5000 WHILE 1 = 1 BEGIN INSERT INTO customer_final WITH (TABLOCK) (ID,Name,Area,CheckSum) SELECT TOP(@BatchSize) ID,Name,Area,CheckSum FROM customer WHERE NOT EXISTS (select 1 from customer_final where customer_final.CheckSum = customer.CheckSum) IF @@ROWCOUNT < @BatchSize BREAK END GO
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
20 Experts available now in Live!