[dbo].[pubsum]

[dbo].[pubsum]

Properties
Columns
Permissions
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	11:10:20 AM Wednesday, March 07, 2007
Last Modified	4:54:36 PM Tuesday, May 05, 2009

Columns

Name
pubname
count

Permissions

Type	Action	Owning Principal
Grant	Select	aiadmin
Grant	Select	aipublic

SQL Script

CREATE view  pubsum AS SELECT ai_pubdef_prop.pubname, SUM(ai_swdef_instcnt_kpi.count) AS "count" FROM  ai_swdef_instcnt_kpi INNER JOIN  ai_swdef_prop ON ai_swdef_instcnt_kpi.swuuid = ai_swdef_prop.swuuid INNER JOIN  ai_pubdef_prop ON ai_pubdef_prop.pubuuid = ai_swdef_prop.pubuuid where pubname!= '' GROUP BY ai_pubdef_prop.pubname
GO
GRANT SELECT ON  [dbo].[pubsum] TO [aiadmin]
GRANT SELECT ON  [dbo].[pubsum] TO [aipublic]
GO

Uses

[dbo].[ai_pubdef_prop]
[dbo].[ai_swdef_instcnt_kpi]
[dbo].[ai_swdef_prop]
dbo