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