Wrox Programmer Forums
|
BOOK: Microsoft SQL Server 2008 Integration Services Problem-Design-Solution
This is the forum to discuss the Wrox book Microsoft SQL Server 2008 Integration Services Problem-Design-Solution by Erik Veerman, Jessica M. Moss, Brian Knight, Jay Hackney ; ISBN: 978-0-470-52576-0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Microsoft SQL Server 2008 Integration Services Problem-Design-Solution section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 6th, 2011, 10:56 PM
Registered User
 
Join Date: Jul 2011
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Question Chapter6-Solution Row Score for duplicate rows

Hi,

Regarding - Chapter6-Solution.dtsx package, which process duplicate rows from table inCustomers.

I have one question:
I did not see how the derived column "rowScore" is used after it is populated.

does this make sense to anyone outthere?
Thank you.

Regards,
Minnie
 
Old July 6th, 2011, 11:50 PM
Registered User
 
Join Date: Jul 2011
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi,

I realized that I understand the logic now after I 'walk through' the code against the row-set 'row by row'. The key thing I was missing is that the rows were sorted within the duplicate group already, hence the script only mark the 1st row within the group.

Regards,
Minnie





Similar Threads
Thread Thread Starter Forum Replies Last Post
deleted duplicate rows ks1102 Excel VBA 2 June 2nd, 2009 04:52 AM
Delete Duplicate Rows gregalb SQL Server 2005 2 March 13th, 2009 05:17 AM
How can you delete duplicate rows without using te subhasischakraborty SQL Server 2000 15 October 19th, 2007 06:51 AM
duplicate rows msrnivas Classic ASP Components 1 August 26th, 2004 02:07 AM
Detecting duplicate rows. Daniel Walker PHP Databases 6 June 21st, 2004 02:39 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.