[dbo].[HARLATESTTRUNKINENVVIEW]

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

Name
ENVOBJID
ITEMOBJID
VERSIONOBJID

SQL Script

SET QUOTED_IDENTIFIER OFF
GO

   CREATE VIEW HARLATESTTRUNKINENVVIEW AS
   SELECT HARVIEW.ENVOBJID, HARVERSIONS.ITEMOBJID,
        MAX(HARVERSIONS.VERSIONOBJID) 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'
   AND HARVERSIONS.INBRANCH = 0
   GROUP BY HARVIEW.ENVOBJID, HARVERSIONS.ITEMOBJID

GO