![]() ![]() The purpose of this article is to provide an introduction to Cross Tabs and Pivots and how they can be used to "rotate" data. In other words, you can use a Cross Tab or Pivot to convert or transpose information from rows to columns either for reporting or to convert some special long skinny tables known as EAV's or NVP's into a more typical form data. This is known as creating a PivotTableĀ®, creating a cross-tab report, or rotating data." "Sometimes it is necessary to rotate results so that columns are presented horizontally and rows are presented vertically. I looked for a definition of what a "Cross Tab" actually is and, after a slight modification, couldn't find a better one than what's in SQL Server 2000 Books Online. We've fought and won many battles together.) (This article is dedicated to a good friend and fellow T-SQL warrior, Katrina Wright. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |