DECLARE @data AS TABLE (Id INT NOT NULL, value INT NULL) INSERT INTO @data ( Id, value ) VALUES (1,1) ,(2,20) ,(3,NULL) ,(4,5)