[dbo].[HARALLVERSIONSINENVVIEW]

(local) > harvest > Views > dbo.HARALLVERSIONSINENVVIEW

Properties
Columns
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	5:00:30 AM Monday, March 02, 2009
Last Modified	5:00:30 AM Monday, March 02, 2009

Columns

Name
ENVOBJID
ITEMOBJID
VERSIONOBJID

SQL Script

SET QUOTED_IDENTIFIER OFF
GO

   CREATE VIEW HARALLVERSIONSINENVVIEW AS
   SELECT DISTINCT HARVIEW.ENVOBJID, HARVERSIONS.ITEMOBJID,
        HARVERSIONS.VERSIONOBJID
   FROM HARVIEW JOIN HARVERSIONINVIEW ON HARVIEW.VIEWOBJID = HARVERSIONINVIEW.VIEWOBJID JOIN HARVERSIONS
       ON HARVERSIONINVIEW.VERSIONOBJID = HARVERSIONS.VERSIONOBJID
   WHERE HARVIEW.ENVOBJID > 0
   AND HARVIEW.VIEWTYPE != 'Snapshot'

GO

Uses

[dbo].[HARVERSIONINVIEW]
[dbo].[HARVERSIONS]
[dbo].[HARVIEW]
dbo