I have a similar process where I have to determine if fields have changed for a record and then do something with the new data.  I use...

victordba (3/26/2014)

---

Thank you, @james.jensen1350 for your reply.

I've been using MERGE for many years to do the upsert. And my source and target tables are large, with millions of...

Check the account that SQL Server and SQL Server Agent services are running under. Verify it has permissions to the folder. (SQL Server 2008 R2 on Windows 2008...

Itzik Ben-Gan is the best. I always know I am getting great information when he is the author! I look for his presentations every time I go to...

Very nice article. Yes the title was misleading but definitely eye-catching. The use of a CTE was a great technique - genius! I shamefully was working with...