[dbo].[arg_entitlement_count

[dbo].[arg_entitlement_count_view]

(local) > mdb > Views > dbo.arg_entitlement_count_view

Properties
Columns
SQL Script
Uses
Used By

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	10:33:20 PM Thursday, February 10, 2011
Last Modified	7:00:05 PM Tuesday, April 26, 2011

Columns

Name
object_uuid
entitlement_count

SQL Script

SET QUOTED_IDENTIFIER OFF
GO
CREATE VIEW arg_entitlement_count_view AS SELECT a.primary_object_uuid object_uuid, count(*) entitlement_count FROM arg_actionlk a RIGHT OUTER JOIN arg_actiondf b ON a.lkacadid = b.adid AND 1=b.adtype GROUP BY a.primary_object_uuid

GO

Uses

[dbo].[arg_actiondf]
[dbo].[arg_actionlk]
dbo

Used By

[dbo].[arg_entitlement_summary_view]