@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