CREATE view  RTTStatsColl_statThView AS SELECT RTTStatsColl_stat.server_addr, RTTStatsColl_stat.probe_addr, RTTStatsColl_stat.CtrlAdminIndex, RTTStatsColl_stat.StatsCapturePathIndex, RTTStatsColl_stat.StatsCaptureHopIndex, IntervalDateTime, IntervalDuration, StatsCollectNumDisconnects=case WHEN IntervalDuration= 0 THEN 0 ELSE StatsCollectNumDisconnects/IntervalDuration END, StatsCollectTimeouts=case WHEN IntervalDuration= 0 THEN 0 ELSE StatsCollectTimeouts/IntervalDuration END, StatsCollectBusies=case WHEN IntervalDuration= 0 THEN 0 ELSE StatsCollectBusies/IntervalDuration END, StatsCollectNoConnections=case WHEN IntervalDuration= 0 THEN 0 ELSE StatsCollectNoConnections/IntervalDuration END, StatsCollectDrops=case WHEN IntervalDuration= 0 THEN 0 ELSE StatsCollectDrops/IntervalDuration END, StatsCollectSequenceErrors=case WHEN IntervalDuration= 0 THEN 0 ELSE StatsCollectSequenceErrors/IntervalDuration END, StatsCollectVerifyErrors=case WHEN IntervalDuration= 0 THEN 0 ELSE StatsCollectVerifyErrors/IntervalDuration END FROM  RTTStatsColl_stat
GO
GRANT SELECT ON  [dbo].[RTTStatsColl_statThView] TO [uniadmin]
GO