Views [dbo].[ActivitiesAvgOverdueView]
(local) > mdb > Views > dbo.ActivitiesAvgOverdueView
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created12:38:42 PM Sunday, December 05, 2010
Last Modified12:38:42 PM Sunday, December 05, 2010
Columns
Name
activity
late_avg
process_name
Permissions
TypeActionOwning Principal
GrantSelectaionadmin_group
SQL Script
create view  ActivitiesAvgOverdueView  as SELECT     activity, AVG(time_late) AS late_avg, process_name
FROM ActivitiesLateCompView
GROUP BY activity, process_name
GO
GRANT SELECT ON  [dbo].[ActivitiesAvgOverdueView] TO [aionadmin_group]
GO
Uses
Created 01 August 2011 11:36
Copyright  CA Technologies, Inc. 2011  - All Rights Reserved