DECLARE @startReqd INT, @endReqd INT,
	@startActual INT, @endActual INT;
	
SET @startReqd = 0; SET  @endReqd = 9999;

INSERT INTO tbl (Range_From,Range_to) VALUES (@startActual,@endActual);
IF @startActual > @startReqd
BEGIN
	INSERT INTO tbl (Range_From,Range_to) VALUES (@startReqd,@startActual-1);
END
IF @endActual < @endReqd
BEGIN
	INSERT INTO tbl (Range_From,Range_to) VALUES (@endActual+1,@endReqd);
END

quote:

---

Originally posted by sunitabeck

Would this work for you?

DECLARE @startReqd INT, @endReqd INT,
	@startActual INT, @endActual INT;
	
SET @startReqd = 0; SET  @endReqd = 9999;

INSERT INTO tbl (Range_From,Range_to) VALUES (@startActual,@endActual);
IF @startActual > @startReqd
BEGIN
	INSERT INTO tbl (Range_From,Range_to) VALUES (@startReqd,@startActual-1);
END
IF @endActual < @endReqd
BEGIN
	INSERT INTO tbl (Range_From,Range_to) VALUES (@endActual+1,@endReqd);
END

---

quote:

---

Originally posted by jimf

You'll have to convert then numebrs to varchar and then add the zeroes like

...VALUES( RIGHT('0000'+convert(varchar(4),@startReqd+1,4)
)

Jim

Everyday I learn something that somebody else already knew

---