--SQL_UpdateFixingStatus

declare @jobId varchar(20), @tableId varchar(20), @trayId varchar(20), @FixingStatus int
set @jobId	= '{0}'
set @tableId	= '{1}'
set @trayId	= '{2}'
set @FixingStatus = '{3}'


Update [Green Circle Growers$Container Entry]
Set [Fixing Status] = @FixingStatus
where [Container Type] = 1
and [Job No_]=@jobId
and [Storage No_] = @tableId
and Barcode = @trayId