…brain …hurts
use ePO_SERVER99; --
select BranchNode.NodeName,ipsubnetmask.AutoID,
BranchNode.ParentID,ipsubnetmask.ParentID,
ipsubnetmask.IP_Start,ipsubnetmask.IP_End
from ipsubnetmask join BranchNode
on IPSubnetMask.ParentID = BranchNode.AutoID
where BranchNode.ParentID not in ('1','2')
order by IP_Start;
Handy Software:
- osql (included with MSDE) KB #325003, #241397
- Aqua Data Studio