Update with checking for column name 1

[UnsolvedCoding]

I am working on a project where a update statement is used in a stored procedure. The statement itself isn't that difficult its simply updating a sheet with an inner join to get the correct informtion.

However, I keep getting an error saying that the column I want to update already exists which it does.

Code -

Update Month_end_master
set Shipping_NBR = T.Invoice_Nbr
from Shipping C
inner join Test_DB.dbo.Tracking T
on C.Shipping_NBR =(right ('0000' + T.Lading_nbr, 4))
And C.Shipping_NBR = T.Invoice_Nbr
where c.[Rollback] = 0
and c.Invoice_NBR is null


What am I missing?

 

[UnsolvedCoding]

Correction to the last line of code -

c.Shipping_Nbr is null

 

[markros]

I don't see Month_End_Master table listed in the FROM clause. I would write the above as a SELECT first, then convert to UPDATE.

PluralSight Learning Library

 

[UnsolvedCoding]

Bingo!