ipFrom     ipTo   location
------     ----   ---------
100        105    London
106        110    Brighton

ipAddress    Location
---------    --------
100          London
101          London
102          London
103          London
104          London
105          London
106          Brighton
107          Brighton
108          Brighton
109          Brighton
110          Brighton

DECLARE @Start AS INT, @End AS INT, @Location AS VARCHAR(100)
DECLARE @TempTable AS TABLE ( Location varchar(100) ) 
DECLARE @ResultTable AS TABLE (ip INT, Location VARCHAR(100))

INSERT INTO @TempTable 
SELECT Distinct Location FROM ipaddress
WHILE ( SELECT COUNT(*) FROM @Temptable ) > 0 
BEGIN 
	SELECT TOP 1 @Location = Location FROM @TempTable
	SELECT @Start = ipFrom, @End = ipto FROM ipAddress WHERE Location = @Location 
	WHILE ( @Start < = @End )
	BEGIN 
	INSERT INTO @ResultTable 
	SELECT @Start, @Location 
	SELECT @Start = @Start + 1
	END
DELETE TOP (1) FROM @TempTable
END
--INSERT INTO <your new table name>
SELECT * FROM @ResultTable ORDER BY Location DESC

quote:

---

Originally posted by yosiasz

if you have indexes on ipFrom and ipTo you should be fine using >=@fromip <=@toip. what datatypes are ipFrom ipTo? what are you trying to accomplish?

If you don't have the passion to help people, you have no passion

---