USE AdventureWorksDW
GO

SELECT DISTINCT [OrderNumber] 
FROM	dbo.[vDMPrep] 
WHERE   FiscalYear = '2005'
ORDER BY [OrderNumber]
GO

SELECT [OrderNumber] , [Model] AS [Product], [EnglishProductCategoryName] AS [Category] 
FROM dbo.[vDMPrep] 
WHERE   FiscalYear = '2005'
ORDER BY [OrderNumber]
GO