[dbo].[e2e_apm_ClientSummaryV]

(local) > mdb > Views > dbo.e2e_apm_ClientSummaryV

Properties
Columns
Permissions
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	12:32:08 PM Sunday, December 05, 2010
Last Modified	12:32:08 PM Sunday, December 05, 2010

Columns

Name
CLIENT
COMPLETED
CANCELLED
EXCEPTION
TStamp
CLIENTID

Permissions

Type	Action	Owning Principal
Grant	Select	apmadmin

SQL Script

create view e2e_apm_ClientSummaryV AS SELECT c.client_name AS CLIENT, r.num_complete AS COMPLETED, r.num_cancelled AS CANCELLED, r.num_exception AS EXCEPTION, r.start_datetime AS TStamp, r.client_id AS CLIENTID FROM e2e_apm_client c INNER JOIN e2e_apm_resp_data r ON c.client_id = r.client_id
GO
GRANT SELECT ON [dbo].[e2e_apm_ClientSummaryV] TO [apmadmin]
GO

Uses

[dbo].[e2e_apm_client]
[dbo].[e2e_apm_resp_data]
dbo