document.write('
Data hosted with ♥ by Pastebin.com - Download Raw - See Original
  1. -- simulate data load #1
  2. INSERT Staging.Sales (SaleID, ProductName, PricePaid)
  3.               VALUES (     1,   \'Bicycle\', 1023.00);
  4.  
  5. -- wait 5 seconds            
  6. WAITFOR DELAY \'00:00:05\';      
  7.  
  8. -- simulate data load #2, where Sale 1 has changed in the source system
  9. INSERT Staging.Sales (SaleID, ProductName, PricePaid)
  10.               VALUES (     1,   \'Bicycle\',  999.99);
');