[dbo].[al_installs_covered

[dbo].[al_installs_covered_view]

(local) > mdb > Views > dbo.al_installs_covered_view

Properties
Columns
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	6:20:38 AM Tuesday, October 13, 2009
Last Modified	6:20:38 AM Tuesday, October 13, 2009

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