[dbo].[HARLATESTTRUNKINREPVIEW]

(local) > harvest > Views > dbo.HARLATESTTRUNKINREPVIEW

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
REPOSITOBJID
ITEMOBJID
VERSIONOBJID

SQL Script

SET QUOTED_IDENTIFIER OFF
GO

   CREATE VIEW HARLATESTTRUNKINREPVIEW AS
   SELECT HARITEMS.REPOSITOBJID, HARITEMS.ITEMOBJID,
        MAX(HARVERSIONS.VERSIONOBJID) VERSIONOBJID
   FROM HARITEMS JOIN HARVERSIONS ON HARITEMS.ITEMOBJID = HARVERSIONS.ITEMOBJID
   WHERE HARITEMS.REPOSITOBJID > 0
   AND HARVERSIONS.INBRANCH = 0
   GROUP BY HARITEMS.REPOSITOBJID, HARITEMS.ITEMOBJID

GO

Uses

[dbo].[HARITEMS]
[dbo].[HARVERSIONS]
dbo