CREATE TABLE dbo.ClientData

([Name]char(8),

[Product]char(4),

[Participant]char(6),

[Route]char(9))

INSERT INTO dbo.ClientData

VALUES ('Client A', 'NA', 'NA', '999999999')

INSERT INTO dbo.ClientData

VALUES ('Client B', 'NA', '7777777', 'NA')

INSERT INTO dbo.ClientData

VALUES ('Client C', '0000', 'NA', 'NA')

Added the table and...

Thank you for the reply.

Thanks everybody, but maybe I did not explain this very well. The user in this case will not have BIDS nor SQL Server installed on their machine. I...

Has the league already closed or can others join?

Yes, thank you very much for your time. However, I should of looked at my code a little better as I had the two strategy columns listed as not...

I have discovered the answer to my own question. In looking back at what I found and asking that question I feel rather stupid. Thank you to all...

Des Moines, Iowa.

Sunny

Temp 4 degrees with a windchill of -8

Thank you to everybody.

Thank you for your assistance.

You are recommending against the use of all 12 columns as a primary key? Just want to make sure that I understood your reply.

Thank you very much for both of your insights to this problem. I like the idea of the identity and then the unique index over the 12 columns. ...

CREATE TABLE [Database].[dbo].[Table_Stage]

([AccountNumber]char(16),

[Name]varchar(26),

[Address]varchar(26),

[Checksum_Col]AS Checksum([AccountNumber], [Name], [Address]))

CREATE [Database].[dbo].[Table_Base]

([AccountNumber]char(16),

[Name]varchar(26),

[Address]varchar(26))

/*----------------------------------------------------------------------------------------------------------------------------

Delete where not exists.

----------------------------------------------------------------------------------------------------------------------------*/

DELETE

FROM [Database].[dbo].[Table_Base]

WHERE [AccountNumber] NOT IN(SELECT [AccountNumber] FROM [Database].[dbo].[Table_Stage]) --delete based upon business key

/*----------------------------------------------------------------------------------------------------------------------------

Update records that...

I have not forgotten about mock-up. Having a busy Friday.

Business requirements state that I am not allowed to truncate the base table as it needs to available at all times. I will work on a mockup for you...

Here is a link for Phil Brammer article on using the checksum component for ssis.

http://www.ssistalk.com/2007/03/09/ssis-using-a-checksum-to-determine-if-a-row-has-changed/

When I implemented the checksum, I did all of it from T-SQL. Allow...