CREATE view  M2ipStatsThView AS SELECT M2ipStats.server_addr, M2ipStats.probe_addr, IntervalDateTime, IntervalDuration, ipInReceives=case WHEN IntervalDuration= 0 THEN 0 ELSE ipInReceives/IntervalDuration END, ipInHdrErrors=case WHEN ipInReceives= 0 THEN 0 ELSE ipInHdrErrors/ipInReceives END, ipInAddrErrors=case WHEN ipInReceives= 0 THEN 0 ELSE ipInAddrErrors/ipInReceives END, ipForwDatagram=case WHEN IntervalDuration= 0 THEN 0 ELSE ipForwDatagrams/IntervalDuration END, ipInUnknownProtos=case WHEN ipInReceives= 0 THEN 0 ELSE ipInUnknownProtos/ipInReceives END, ipInDiscards=case WHEN ipInReceives= 0 THEN 0 ELSE ipInDiscards/ipInReceives END, ipInDelivers=case WHEN ipInReceives= 0 THEN 0 ELSE ipInDelivers/ipInReceives END, ipOutRequest=case WHEN IntervalDuration= 0 THEN 0 ELSE ipOutRequests/IntervalDuration END, ipOutDiscards=case WHEN (ipOutRequests+ipForwDatagrams)= 0 THEN 0 ELSE ipOutDiscards/(ipOutRequests+ipForwDatagrams) END, ipOutNoRoutes=case WHEN (ipOutRequests+ipForwDatagrams)= 0 THEN 0 ELSE ipOutNoRoutes/(ipOutRequests+ipForwDatagrams) END, ipReasmFails=case WHEN ipInReceives= 0 THEN 0 ELSE ipReasmFails/ipInReceives END, ipFragFails=case WHEN (ipOutRequests+ipForwDatagrams)= 0 THEN 0 ELSE ipFragFails/(ipOutRequests+ipForwDatagrams) END FROM  M2ipStats
GO
GRANT SELECT ON  [dbo].[M2ipStatsThView] TO [uniadmin]
GO