@MaxRows) UNION ALL SELECT TOP (@MaxRows) 'Document' AS [Class] ,[Owner] ,[Type] ,[Number] ,ItemId AS [HK100] ,Description AS [Name] ,CASE WHEN [PendingRevision] IS NOT NULL THEN [PendingRevision] ELSE [Revision] END AS [Revision] ,CASE WHEN [PendingLifecycle] IS NOT NULL THEN [PendingLifecycle] ELSE [Lifecycle] END AS [Lifecycle] ,CASE WHEN [PendingRevision] IS NOT NULL THEN 'Pending' WHEN [IsCanceled] = 'FALSE' THEN 'Released' ELSE 'Canceled' END AS [Status] ,CASE WHEN [IsHomeItem] = 0 THEN 'Partner' ELSE 'Home' END AS [Issuer] FROM [viewer].[ItemView] WHERE [Class] = 2 ORDER BY [Owner],[Type],[Number] ]]> DataGrid