Summary
Keywords
Full Transcript
sql server convert columns to rows in a table sql server transpose columns to rows unpivot in sql server example sql server unpivot example In this video we will discuss UNPIVOT operator in SQL Server. Healthy diet is very important both for the body and mind. If you like Aarvi Kitchen recipes, please support by sharing, subscribing and liking our YouTube channel. Hope you can help. https://www.youtube.com/channel/UC7sEwIXM_YfAMyonQCrGfWA/?sub_confirmation=1 PIVOT operator turns ROWS into COLUMNS, where as UNPIVOT turns COLUMNS into ROWS. We dicussed PIVOT operator in Part 54 of SQL Server tutorial. Please watch Part 54 before proceeding. http://csharp-video-tutorials.blogspot.com/2012/10/pivot-operator-in-sql-server-part-54.html Let us understand UNPIVOT with an example. We will use the following tblProductSales table in this demo. SQL Script to create tblProductSales table Create Table tblProductSales ( SalesAgent nvarchar(50), India int, US int, UK int ) Go Insert into tblProductSales values ('David', 960, 520, 360) Insert into tblProductSales values ('John', 970, 540, 800) Go Write a query to turn COLUMNS into ROWS. SELECT SalesAgent, Country, SalesAmount FROM tblProductSales UNPIVOT ( SalesAmount FOR Country IN (India, US ,UK) ) AS UnpivotExample Text version of the video http://csharp-video-tutorials.blogspot.com/2015/10/unpivot-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2015/10/unpivot-in-sql-server_10.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
