SQ Query for Product Distributors

[joecalardo]

Hello, does anyone know a quick sql query that will let me delete the distributor ID's from my Product's and insert new ones, I am trying to change a few things doing a mass upload via excel copy and paste.

If BFG is there ? Maybe you can help me out ?! :-P

Basically ... ProductID is A2, DistributorID is B2 . Thanks! Need a quick copy down and paste statement.

Thanks!

[BFG 9000]

Something like this - (untested)...

="UPDATE ProductDistributor SET DistributorID = "&B2&" WHERE ProductID = "&A2&";" 

TTFN

BFG

[joecalardo]

Damnit, no good. Gave me this for some products

Violation of PRIMARY KEY constraint 'PK_ProductDistributor'. Cannot insert duplicate key in object 'dbo.ProductDistributor'.
The statement has been terminated.


:-\ Any other suggestions ? Would doing a Delete from and then insert into statement posisbly work ?

[BFG 9000]

Did you copy & paste that exactly?

I can't see how updating the DistributorID in that table could ever give you that error message.



TTFN

BFG

[esedirect]

It only means that the row with the unique combination of ProductID and DistributorID already exists. You cannot have 2 records with those being the same in the db.

[BFG 9000]

& when you're only updating the DistributorID of an already existing row, this error shouldn't appear...