UNPIVOT in SQL Server

[@mosesamponsah4824]

Very simple procedure. Thank you for sharing

[@krzysztofs8535]

Thank U for educating community! You are master of SQL Server and the way of your style of teaching is just superb! Best regards from Poland ! Keep goin' please!

[@Ngen0519]

Extremely clear and concise instructions. Thanks!

[@nehasingh-ue1gi]

This is just amazing :) Part 55* for pivot in sql server

[@LUPECARREON]

Thank you Sr. You are making my life much easier :)

[@lewisshaw4421]

Thanks for this, much easier to understand via video then the written word.

[@lahubhawar696]

Thank you very much for such a detailed and clear explanation

[@AmitKumar-pc3ly]

Excellent Video ! Well Explained Venkat !

[@rahmiul1980]

God bless you Sir..

[@jasons7310]

Hello Venkat, your videos are great and have helped me a great deal so I thank you! I was wondering if you will be doing a video on using Client Statistics and Execution Plans soon?

[@OsmanOlmedo]

thanks. Very clear explanation.

[@shreyanair7347]

Understood 😉 clearly

[@poonammahto6442]

thank u so much for this video

[@zhussupbekzhidebay7990]

Thanks a lot! It helped me solve problem!

[@johnnyvlee]

That was a very clear example, which is great. But could you go a bit more in-depth with more complex examples? For example, I have a case where I want to Unpivot 36 columns in a table into 36 rows with the column name and the value from that column, but the data types in each column are not identical.

[@CalifGirl000]

Thanks. Very clear explanation. I was confused on how to use UNPIVOT until I watched your video.

[@Csharp-video-tutorialsBlogspot]

Thank you very much for taking time to give feedback. This means a lot. I am very glad you found the videos useful.
I have organised all the Dot Net & SQL Server videos in to playlists, which could be useful to you
th-cam.com/users/kudvenkatplaylists?view=1&sort=dd
If you need DVDs or to download all the videos for offline viewing please visit
www.pragimtech.com/order.aspx
Slides and Text Version of the videos can be found on my blog
csharp-video-tutorials.blogspot.com
Tips to effectively use my youtube channel.
th-cam.com/video/y780MwhY70s/w-d-xo.html
If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel.
th-cam.com/users/kudvenkat
If you like these videos, please click on the THUMBS UP button below the video.
May I ask you for a favor. I want these tutorials to be helpful for as many people as possible. Please share the link with your friends and family who you think would also benefit from them.
Good Luck
Venkat

[@yadiramedinacometa1901]

Excelente ayuda, gracias.

[@gp7178]

Thank you for this video Venkat. Is there a way to dynamically use the Upivot operator?

[@raqibulAlam-su3jo]

Nice tutorial.

[@KevinNguyenSESE]

Thank you for this great video. Might I ask a question? Suppose there are two types of fields that needs to be unpivoted. For your example you unpivot three countries into a new field 'country'. But let's suppose for each of those three country there is a field indicating market strength. So in my result table I would like {sales agent; country; marketstrength; salesamount}. The method to do this in excel requires concatenation then splitting. What is the SQL method? I am trying to automate some data transformation for analysis. Thank you for any help.

[@TheCarloszoom3000]

Hi. I have a table and by doing the selection (SELECT `value`,`title`FROM `jos_facileforms_subrecords` WHERE `record`=80), I get the value and title, each one being a column with records below them. How would it apply to make the title values all the rows and the value records the row below that?
I appreciate your help.
Regards,

[@murlimohanmahalanka3213]

Hi venkat .. why u have use alias name for unpivot i.e unpivotexample . where it is used.

[@Yoemer94]

Thanks a lot!

[@anastasiia3840]

Thank you!!!

[@sarumathi9]

Am getting Error While executing the query like Sub query does not contain the unpivoting column(s) 'India, US, UK', mentioned in the UNPIVOT operator.

[@claudiofondital5871]

Thank you!

[@richardwood8815]

Thank you :-)

[@girishggirishg1083]

Can anyone suggest, what is the alternative for this pivot/unpivot method in MySQL?

[@muhammadrehbarsheikh8498]

Thanks sir!!

[@venudamarla4349]

Hello Venkat. I am trying to get calendar weeks as column names weekending is sunday for 1 year. if the month has started again it need to start as 1st week of that month
example: Jan has ( 6 weeks (1, 2-8, 9-15, 16-22, 23-39,30-31)) in Feb has 5 weeks
January: 123456, February: 6,7,8 instead of that 12345
I want this results because i am getting count results based on month, weeks how to write query for my requirement

[@binbinbinvininfo6992]

Hello after this how can I save the unpivoted table in SQL Server?

[@prathyushasaineni6999]

hello sir explain about delete and truncate sir........

[@arunanthony7534]

Is there another way to unpivot

[@valijoneshniyazov3859]

where to download database!?

[@valijoneshniyazov3859]

were is database?

[@paragpujari3961]

error coming

[@israkvelvarga993]

An university course free

[@ivannasoton]

thank you soo much!

[@zeee9522]

Thank you!