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?

ExtraValueIDContactID

982037838

982037854

982038392

9820310162

9820310185

9820310238

9820310887

9820312466

9820312568

9820313579

9820314572

9820344282

9820344946

9820345919

9820346268

9820346645

9820347667

9820348318

9820348377

9820348414

9820348416

9820348417

9820348638

9820348690

9820348708

9820348710

9820348809

9820348992

9820349767

9820349965

9820350217

9820350222

9820350414

9820350653

9820350763

9820350787

9820350845

9820351221

9820351514

9820351541

9820351559

9820351775

9820351921

9820352308

9820352540

9820352673

9820352771

9820352772

9820352879

9820352880

9820354934

9820354935

9820355089

9820355482

9820355511

9820355606

9820355736

9820356306

9820356992

9820356994

9820357188

9820358035

9820358036

9820358098

9820363681

9820366761

9820367954

9820368893

9820369227

9820370627

9820373038

9820373039

9820373040

9820373355

9820373426

9820374299

9820374572

9820374574

9820374708

9820374720

9820374928

9820375030

9820375329

9820375559

9820375617

9820376899

9820378351

9820378847

9820379868

9820380161

9820380302

9820380435

9820380501

9820380740

9820380777

9820381135

9820381182

9820381427

9820384255

9820384866

9820384868

9820384873

9820385012

9820385379

9820386126

9820386183

9820386634

9820386669

9820386695

9820386820

9820386821

9820386948

9820387617

9820387727

9820387836

9820387954

9820388034

9820388163

9820388173

9820388266

9820388445

9820388508

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,...