Thank you for your response,

How can I do this?

If i do the first option I keep getting an annoying...

Fantastic, that did it!

Never thought of a case, was messing with left outer joins.

Thanks

Looks like I just needed to do this

GRANT EXECUTE ON OBJECT::dbo.storedProc TO user;

The update returns an error on the first line

Incorrect syntax near the keyword 'as'.

But I don't want to show these columns anymore in the Audit table. In the Audit table...

This is what I was trying

UPDATE [Audit] as a

SET a.BatchID = b.Id

FROM Audit as a inner join Batch as b on a.BatchCode = b.Name

AND a.BestBeforeDate = b.BestBefore

AND a.ProductionDate = b.ProductionDate

//Edit

BatchCode,...