THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Alberto Ferrari

Table Difference 1.1

TableDifference has been updated to version 1.1.

The major improvement is the fact that now TableDifference can handle a field as

  • Key: a field that represent a key in the table, you must supply KeyOrder
  • Compare: a field that is to be compared between OLD and NEW, you must supply UpdateID
  • PreferNEW: the field appear in both flows but you want the value from the NEW flow
  • PreferOLD: the field appear in both flows but you want the value from the OLD flow.

Mostly valuable implementation is PreferOLD, in this way you can use the ID of the OLD table in the subsequent flows to make any kind of update you want in an easier way.

You can find the whole article and source code on www.sqlbi.eu.

Published Thursday, July 06, 2006 9:48 AM by AlbertoFerrari

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

No Comments

Leave a Comment

(required) 
(required) 
Submit

About AlbertoFerrari

Alberto Ferrari is a Business Intelligence consultant. He his interests lie in two main areas: BI development lifecycle methodologies and performance tuning of ETL and SQL code. His main activities are with SSIS and SSAS for the banking, manufacturing and statistical sectors. He is also a speaker in international conferences like European PASS Conference and PASS Summit.
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement