CREATE view  RTTJitter_statThView AS SELECT RTTJitter_stat.server_addr, RTTJitter_stat.probe_addr, RTTJitter_stat.CtrlAdminIndex, IntervalDateTime, IntervalDuration, JitterStatsOverThresholds=case WHEN JitterStatsNumOfRTT= 0 THEN 0 ELSE JitterStatsOverThresholds/JitterStatsNumOfRTT END, JitterStatsRTTSum=case WHEN JitterStatsNumOfRTT= 0 THEN 0 ELSE JitterStatsRTTSum/JitterStatsNumOfRTT END, JitterStatsPacketLossSD=case WHEN JitterStatsNumOfRTT= 0 THEN 0 ELSE JitterStatsPacketLossSD/JitterStatsNumOfRTT END, JitterStatsPacketLossDS=case WHEN JitterStatsNumOfRTT= 0 THEN 0 ELSE JitterStatsPacketLossDS/JitterStatsNumOfRTT END, JitterStatsPacketOutOfSequence=case WHEN JitterStatsNumOfRTT= 0 THEN 0 ELSE JitterStatsPacketOutOfSequence/JitterStatsNumOfRTT END, JitterStatsPacketLateArrival=case WHEN JitterStatsNumOfRTT= 0 THEN 0 ELSE JitterStatsPacketLateArrival/JitterStatsNumOfRTT END, JitterStatsError=case WHEN JitterStatsNumOfRTT= 0 THEN 0 ELSE JitterStatsError/JitterStatsNumOfRTT END, JitterStatsBusies=case WHEN JitterStatsNumOfRTT= 0 THEN 0 ELSE JitterStatsBusies/JitterStatsNumOfRTT END FROM  RTTJitter_stat
GO
GRANT SELECT ON  [dbo].[RTTJitter_statThView] TO [uniadmin]
GO