The ROW_NUMBER function returns the ordinal row position of each row in a grouping within a result set. This function can be very useful for generating reports.
select ROW_NUMBER() over(PARTITION BY PC.Name ORDER BY ListPrice) as Row, PC.Name Category, P.Name Product, P.ListPrice From Production.Product P JOIN Production.ProductSubcategory PSC on P.ProductSubCategoryID = PSC.ProductSubCategoryID JOIN Production.ProductCategory PC on PSC.ProductCategoryID = PC.ProductCategoryID
Dig deeper on Microsoft SQL Server Database Development
Getting an error when importing data from an Excel spreadsheet to SSIS in SQL Server 2005? Try lining up data types in Excel and SSIS so they match.continue reading
Convert SQL Server 2000 DTS packages to SQL Server 2005 with this advice and also see how to overwrite data.continue reading
Migrate DTS packages to SQL Server Integration Services with Migration Wizard and deploy SSIS packages in SQL 2005. Learn how to access DTS Designer ...continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.