[dbo].[al_installs_covered

[dbo].[al_installs_covered_view]

(local) > mdb > Views > dbo.al_installs_covered_view

Properties
Columns
SQL Script
Uses
Used By

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	7:00:21 PM Tuesday, April 26, 2011
Last Modified	7:00:21 PM Tuesday, April 26, 2011

Columns

Name
block_id
installs_covered

SQL Script

SET QUOTED_IDENTIFIER OFF
GO
create view al_installs_covered_view as
select block_id, count(0) as installs_covered
from al_compliance_status_view
where block_id is not null group by block_id
GO

Uses

[dbo].[al_compliance_status_view]
dbo

Used By

[dbo].[al_bi_hyperlinks_view]