If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link [ Ссылка ] to make a donation. Thanks for watching!

By Andrew Gould

[ Ссылка ] - The Pivot Operator in Microsoft SQL Server allows you to group data by columns, as well as by rows, to create simple static pivot tables. This video teaches you how to use the pivot operator including how to apply aggregate functions and, importantly, a quick method for listing out the column headings of your pivot table using the QuoteName function.

You can download the script to create the Movies database used in this video at the following link:
[ Ссылка ]

You can view a written version of this tutorial at:
[ Ссылка ]

You can see the range of resources and courses we offer in SQL Server here:
[ Ссылка ]

Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!

свернуть