@MaxRows) UNION ALL SELECT TOP (@MaxRows) 'Part' 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] ,DefaultUOM AS [Units] ,CAST(CAST(CostPerUnit AS decimal(18,4)) AS nvarchar(20)) AS [Cost] FROM [viewer].[ItemView] WHERE [Class] = 1 ORDER BY [Owner],[Type],[Number] ]]> DataGrid