MS SQL Server 2012 Von: [email protected] [mailto:[email protected]] Im Auftrag von D R Gesendet: Mittwoch, 29. Juli 2015 16:36 An: [email protected] Betreff: Re: [mssms] SQL guru needed...
Which version of SQL? MS, Postgre, MySQL, Oracle? On Wed, Jul 29, 2015 at 9:23 AM, Kehl Reto <[email protected]<mailto:[email protected]>> wrote: need sql query for ip addresses sorted ascending but can’t get the 4th octet SELECT IPAddress0, DNSHostName0 FROM v_GS_NETWORK_ADAPTER_CONFIGURATION WHERE (v_GS_NETWORK_ADAPTER_CONFIGURATION.IPEnabled0 = 1) ORDER BY CAST(SUBSTRING(IPAddress0, 1, CHARINDEX('.', IPAddress0) - 1) AS tinyint), CAST(SUBSTRING(IPAddress0, CHARINDEX('.', IPAddress0) + 1, CHARINDEX('.', IPAddress0, CHARINDEX('.', IPAddress0) + 1) - CHARINDEX('.', IPAddress0) - 1) AS tinyint), CAST(SUBSTRING(IPAddress0, CHARINDEX('.', IPAddress0, CHARINDEX('.', IPAddress0) + 1) + 1, CHARINDEX('.', IPAddress0, CHARINDEX('.', IPAddress0, CHARINDEX('.', IPAddress0) + 1) + 1) - CHARINDEX('.', IPAddress0, CHARINDEX('.', IPAddress0) + 1) - 1) AS tinyint) --CAST(SUBSTRING(IPAddress0, CHARINDEX('.', IPAddress0, CHARINDEX('.', IPAddress0, CHARINDEX('.', IPAddress0) + 1) + 1) + 1, 3) AS tinyint) the last CAST(SUBSTRING(…. gives error when activated. I can’t get it, way too complicated for me.. anybody? -- Daniel Rodriguez [email protected]<mailto:[email protected]>
