Differences between revisions 3 and 4
⇤ ← Revision 3 as of 2015-09-20 17:40:01 →
Size: 389
Editor: 71-88-115-101
Comment:
← Revision 4 as of 2015-09-20 17:41:13 → ⇥
Size: 532
Editor: 71-88-115-101
Comment:
Deletions are marked like this. Additions are marked like this.
Line 13: Line 13:
To sort via the IP address now do the following:

{{{#!highlight sql
SELECT IpAddress, Reserved
FROM IpPoolABCD
ORDER BY A, B, C, D
}}}

Dhcp Reservations

2015-09-20

Added a view to the DB so that we can sort on the IP address easily: 

   1 CREATE VIEW IpPoolABCD AS
   2 SELECT *, CAST(PARSENAME(IpAddress,4) AS INT) AS A,
   3           CAST(PARSENAME(IpAddress,3) AS INT) AS B,
   4           CAST(PARSENAME(IpAddress,2) AS INT) AS C,
   5           CAST(PARSENAME(IpAddress,1) AS INT) AS D
   6 FROM IpPool

To sort via the IP address now do the following: 

   1 SELECT IpAddress, Reserved
   2 FROM IpPoolABCD
   3 ORDER BY A, B, C, D

CsNetworkApps/DhcpReservations (last edited 2015-09-20 17:41:43 by 71-88-115-101)