Many thanks for the info Lynn

No the tabs are not needed as it's a user input error copying from a spreadsheet i should imagine.

Whenever a client code is amended the second script is then run...

Thanks for the info I thought you were asking me to drop and recreate the table, and it was only after i ran the script did i notice the tags!!...

Many thanks for the responses their was a problem with the placement with the brackets but once moved this corrected the problem and the client code updated ok and now...

Forget the HTML tags!! 🙂

I won't be able to drop the table due to keys in place (1 primary and 13 foreign) but when using the update section of the code above:

UPDATE clientsupplier ...

It doesn't look like they are tab characters as when running the script above the following error message gets returned:

Conversion failed when converting the varchar value 'LC157790 ' to data type...

Aplogies for the confusion, the white space is to the right of the code

So it looks something like LC157790[][][]

When i tried to copy and paste this onto the forum...

Thanks again Chris, have yourself a great weekend 😀

Thanks for the heads up Chris, i ran your script with the Insert commented out which returned 10871 rows if you add this to the 122 records this totals 10993,...

122 rows affected btw

Apparently somebody has been updating the field, wouldn't the AND NOT EXISTS take care of this?

ExtraValueID ContactID

98203 7838

98203 7854

98203 8392

98203 10162

98203 10185

98203 10238

98203 10887

98203 12466

98203 12568

98203 13579

98203 14572

98203 44282

98203 44946

98203 45919

98203 46268

98203 46645

98203 47667

98203 48318

98203 48377

98203 48414

98203 48416

98203 48417

98203 48638

98203 48690

98203 48708

98203 48710

98203 48809

98203 48992

98203 49767

98203 49965

98203 50217

98203 50222

98203 50414

98203 50653

98203 50763

98203 50787

98203 50845

98203 51221

98203 51514

98203 51541

98203 51559

98203 51775

98203 51921

98203 52308

98203 52540

98203 52673

98203 52771

98203 52772

98203 52879

98203 52880

98203 54934

98203 54935

98203 55089

98203 55482

98203 55511

98203 55606

98203 55736

98203 56306

98203 56992

98203 56994

98203 57188

98203 58035

98203 58036

98203 58098

98203 63681

98203 66761

98203 67954

98203 68893

98203 69227

98203 70627

98203 73038

98203 73039

98203 73040

98203 73355

98203 73426

98203 74299

98203 74572

98203 74574

98203 74708

98203 74720

98203 74928

98203 75030

98203 75329

98203 75559

98203 75617

98203 76899

98203 78351

98203 78847

98203 79868

98203 80161

98203 80302

98203 80435

98203 80501

98203 80740

98203 80777

98203 81135

98203 81182

98203 81427

98203 84255

98203 84866

98203 84868

98203 84873

98203 85012

98203 85379

98203 86126

98203 86183

98203 86634

98203 86669

98203 86695

98203 86820

98203 86821

98203 86948

98203 87617

98203 87727

98203 87836

98203 87954

98203 88034

98203 88163

98203 88173

98203 88266

98203 88445

98203 88508

Wrong use of words sorry, the ExtraContact table holds the information about the Contact records so i need to insert the information into there

Apologies for the confusion

/****** Object: Table [dbo].[ExtraContact] Script Date: 04/03/2009 10:14:10 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[ExtraContact](

[ExtraValueID] [int] NOT NULL,

[ContactID] [int] NOT NULL,

CONSTRAINT [PK_ExtraContact] PRIMARY KEY CLUSTERED...

Thanks to all for your advice, not sure why i didn't come here sooner but that would be to easy i supoose. It's good to tax the old grey matter,...