Views [dbo].[locationsum]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created6:13:11 PM Tuesday, May 05, 2009
Last Modified6:13:11 PM Tuesday, May 05, 2009
Columns
Name
countofregion
region
Permissions
TypeActionOwning Principal
GrantDeleteaiadmin
GrantInsertaiadmin
GrantSelectaiadmin
GrantUpdateaiadmin
GrantSelectaipublic
SQL Script

        CREATE    VIEW dbo.locationsum
        AS
        SELECT    TOP 200 COUNT(region) AS countofregion,
            region
        FROM    dbo.ai_oldef_prop
        GROUP BY region
        ORDER BY COUNT(region) DESC, region
        
GO
GRANT SELECT ON  [dbo].[locationsum] TO [aiadmin]
GRANT INSERT ON  [dbo].[locationsum] TO [aiadmin]
GRANT DELETE ON  [dbo].[locationsum] TO [aiadmin]
GRANT UPDATE ON  [dbo].[locationsum] TO [aiadmin]
GRANT SELECT ON  [dbo].[locationsum] TO [aipublic]
GO
Uses
Used By