i have imported data from excel to sql, from this data i am looking to do an update on SQL data by using the below code,
it is returning with the below error, there isnt even such thing as dbo.products! from initial searches it refers to a padding issue? can anyone advise?
Msg 2627, Level 14, State 1, Procedure InvMasterIU, Line 38
Violation of UNIQUE KEY constraint 'UQ__Products__014935CB'. Cannot insert duplicate key in object 'dbo.Products'.
The statement has been terminated.
SET Ebq = mps.EBQ, BuyingRule = mps.BatchingRule, MpsFlag = mps.MPSItem, GrossReqRule = mps.GrossReq
From InvMaster as i JOIN mal.dbo.MPSData mps
ON mps.StockCode = i.StockCode