SORTING PCS IN SITES (NUMBER)

What scripting language, is the information already in a particular file format or are you hoping to capture this information as well.

Are you trying to do this in SQL?

If so you could do something like

SELECT * FROM YourTable WHERE Site = 1 ORDER BY IP
UNION ALL
SELECT * FROM YourTable WHERE Site = 2 ORDER BY IP

mlmcc

@DRRAM

You have SQL as one of the zones for this question.  Is your data already in a database?  If so, which one?

EXCEL OR MYSQL

Thx verry good

you're welcome.

Please be aware that the SQL solves the problem as stated.  If you throw different data into the mix, you might not get the desired results.  The reason for this is that the [IP Address], [Start IP Address], and [End IP Address] values are strings.  As such, the Between operator might not find the correct slot, if any, for the rows to be joined.

If you need to configure this for regular production use, you should probably store these ranges as BigInt values and use the INET_ATON() function to compare the IP addresses numerically.  While you could invoke the  INET_ATON() function on the range values, it would make for very inefficient queries.

http://dev.mysql.com/doc/refman/5.0/en/miscellaneous-functions.html#function_inet-aton

Example:

Select Scope, Count(Scope) As SiteCount
From SiteTable, IP_Log
Where INET_ATON(Ip_Log.[IP Address]) Between SiteTable.[Start IP Address] And SiteTable.[End IP Address]
Group By Scope

Select allOpen in new window

thank you very much  is perfect