SQL Server Planet

Using the Merge Statement to populate a historical table with Effective Dating

Posted by Derek Dieter on 3 June 2009, 10:31 pm

One of my favorite uses for the MERGE statement introduced in SQL Server 2008 is the updating of a historical table. With versions prior to 2008 this operation had to be performed in two separate statements. Merge helps us to streamline the process. The advantage to the database engine when using a Merge statement is [...]

Random MVP RSS Feeds

[Bill Graziano] How to tell what your insert, update or delete is doing: Lately I’ve been working on a data migrat... http://bit.ly/9py44l about 19 hours ago from twitterfeed

[Simon Sabin] New training session for SQLBits: After some thought we’ve decided to change Buck Woody’s training d... http://bit.ly/9uK7ws about 22 hours ago from twitterfeed

[Simon Sabin] Only a few places left for the SQLBits training days: All the training day sessions for SQLBits 7 ar... http://bit.ly/99AQOE 05:32:14 PM September 02, 2010 from twitterfeed

[SQL Aloha] Interview with the Intrepid Buck Woody: This is the second in a series of interviews with speakers pre... http://bit.ly/ddBqTW 05:15:53 PM September 02, 2010 from twitterfeed

[Simon Sabin] Dates don’t work when copied from SQL Profiler - Error converting data type varchar to datetime: If ... http://bit.ly/9pudqc 09:51:00 AM September 02, 2010 from twitterfeed

[SQL Aloha] As a PASS Member, Don’t Forget to Vote in the 2010 PASS Board Elections: I just received my e-mail fro... http://bit.ly/9eB8Sa 01:20:04 AM September 02, 2010 from twitterfeed

[SQL Aloha] September Question: What feature is missing from SQL Server that you would most like to see included i... http://bit.ly/afuN04 08:51:22 PM September 01, 2010 from twitterfeed

[Simon Sabin] SQLBits registrations – Early bird closing soon: Its great to see registrations flying in. Don’t for... http://bit.ly/cgCWB3 12:59:43 PM September 01, 2010 from twitterfeed

[SQL Aloha] Interview with SQL Server MVP Glenn Berry: This is a first of a series of interviews with speakers pre... http://bit.ly/ddJpjp 03:28:21 AM September 01, 2010 from twitterfeed

[Bill Graziano] When does SQL Server decimal NOT convert to .Net decimal?: Having the SSMS Tools Pack out in the w... http://bit.ly/9hwauF 06:21:12 PM August 31, 2010 from twitterfeed

SQL Server Planet

Using the Merge Statement to populate a historical table with Effective Dating

Random MVP RSS Feeds

Newsletter Signup

Connect

Categories