Views [dbo].[ActivitiesAvgOverdueView]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnNo
Created2:23:22 PM Friday, March 21, 2008
Last Modified2:23:22 PM Friday, March 21, 2008
Columns
Name
activity
late_avg
process_name
Permissions
TypeActionOwning Principal
GrantSelectaionadmin_group
SQL Script
SET QUOTED_IDENTIFIER OFF
GO

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