-- SQL_GetTableWithNoFixStatus declare @jobId varchar(20), @tableId varchar(20) set @jobId = '{0}' set @tableId = '{1}' SELECT [Job No_] ,[Barcode] ,[Storage No_] FROM [Green Circle Growers$Container Entry] where [Job No_] = @jobId and [Storage No_] = @tableId and [Fixing Status] = 0