UNPIVOT in SQL Server

[@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!

[@mosesamponsah4824]

Very simple procedure. Thank you for sharing

[@Ngen0519]

Extremely clear and concise instructions. Thanks!

[@lewisshaw4421]

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

[@LUPECARREON]

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

[@nehasingh-ue1gi]

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

[@lahubhawar696]

Thank you very much for such a detailed and clear explanation

[@AmitKumar-pc3ly]

Excellent Video ! Well Explained Venkat !

[@rahmiul1980]

God bless you Sir..

[@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
ua-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.
ua-cam.com/video/y780MwhY70s/v-deo.html
If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel.
ua-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

[@OsmanOlmedo]

thanks. Very clear explanation.

[@zhussupbekzhidebay7990]

Thanks a lot! It helped me solve problem!

[@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?

[@raqibulAlam-su3jo]

Nice tutorial.

[@shreyanair7347]

Understood 😉 clearly

[@yadiramedinacometa1901]

Excelente ayuda, gracias.

[@poonammahto6442]

thank u so much for this video

[@Yoemer94]

Thanks a lot!

[@anastasiia3840]

Thank you!!!

[@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.

[@claudiofondital5871]

Thank you!

[@richardwood8815]

Thank you :-)

[@gp7178]

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

[@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.

[@muhammadrehbarsheikh8498]

Thanks sir!!

[@murlimohanmahalanka3213]

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

[@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,

[@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.

[@prathyushasaineni6999]

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

[@girishggirishg1083]

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

[@binbinbinvininfo6992]

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

[@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

[@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!