Page Comparison

SELECT
 CAST(p.objectPackageID AS VARCHAR) groupID,
 p.name title,
 p.notes scopeNote,
 (CASE WHEN u.MTB_ConstituentID = -1 THEN NULL ELSE u.MTB_ConstituentID END) owner,
 p.entereddate dateCreated
FROM
 ObjectPackages p
 LEFT OUTER JOIN Users u ON p.owner = u.login
UNION ALL
SELECT
  'bur' + CAST(o.objectID AS VARCHAR) groupID,
  'Burial lot ' + o.objectNumber title,
  null scopeNote,
  null7252 owner,
  o.entereddate dateCreated
FROM
 Objects o
WHERE
   o.IsTemplate = 0 and o.IsVirtual=1 and o.DepartmentID = 34
 ;