CREATE view  NBARprotocol_statThView AS SELECT NBARprotocol_stat.server_addr, NBARprotocol_stat.probe_addr, NBARprotocol_stat.ifIndex, NBARprotocol_stat.AllStatsProtocolsIndex, IntervalDateTime, IntervalDuration, AllStatsHCInBytes=case WHEN (ifSpeed*IntervalDuration)= 0 THEN 0 WHEN ifSpeed = 1 THEN 0 ELSE 8.0*AllStatsHCInBytes/(ifSpeed*IntervalDuration) END, AllStatsHCOutBytes=case WHEN (ifSpeed*IntervalDuration)= 0 THEN 0 WHEN ifSpeed = 1 THEN 0 ELSE 8.0*AllStatsHCInBytes/(ifSpeed*IntervalDuration) END, ResourceNameNBarView.ifSpeed FROM  NBARprotocol_stat, ResourceNameNBarView WHERE userId = 0 AND ResourceNameNBarView.server_addr=NBARprotocol_stat.server_addr AND ResourceNameNBarView.probe_addr=NBARprotocol_stat.probe_addr AND ResourceNameNBarView.rsrcIndex=NBARprotocol_stat.ifIndex
GO
GRANT SELECT ON  [dbo].[NBARprotocol_statThView] TO [uniadmin]
GO