I think OP's request close to this:SET NOCOUNT ON;DECLARE @T TABLE(ProdNum int PRIMARY KEY, Name VARCHAR(15)); DECLARE @N INTSET @N = 5;INSERT INTO @TSELECT 1, 'X' UNIONSELECT 2, 'X' UNIONSELECT 3, 'X' UNIONSELECT 4, 'X' UNIONSELECT 5, 'X';SELECT MIN(ProdNum) AS start_seq, MAX(ProdNum)AS end_seqFROM @TWHERE Name = 'X'HAVING COUNT(*) = @NAND MAX(ProdNum) - MIN(ProdNum) + 1 = @N/*start_seq end_seq----------- -----------1 5*/