Dynamic Pivot function in sql server | sql dynamic pivot data

แชร์
ฝัง
  • เผยแพร่เมื่อ 22 ม.ค. 2025

ความคิดเห็น • 28

  • @shreyassen4260
    @shreyassen4260 11 หลายเดือนก่อน +2

    Very helpful video ❤
    Thanks for your efforts

  • @jpseasia
    @jpseasia 4 ปีที่แล้ว +1

    I'd been trying to figure out dynamic pivoting for the last hour. Then I found this video and it was super helpful. Thank you.

  • @czamorab
    @czamorab 4 ปีที่แล้ว

    Thanks for the tutorial, just one little feedback, will be nice to have at the end of video a scene with the whole sql script

    • @Training2SQLMSBI
      @Training2SQLMSBI  4 ปีที่แล้ว

      Thanks for your feedback .. appreciate your time..
      Sure .. will try going forward..

  • @johnpower1144
    @johnpower1144 4 ปีที่แล้ว +1

    This is very helpful - one question, how can you reorder the columns in the pivot? So in your example, how would you alphabetically reorder the columns of the results ?

  • @Raj-ph1py
    @Raj-ph1py 5 ปีที่แล้ว +1

    Excellent tutorial

    • @Training2SQLMSBI
      @Training2SQLMSBI  5 ปีที่แล้ว

      Thanks for your feedback .. appreciate your time..

  • @ChandrashekarReddyY-hp4rl
    @ChandrashekarReddyY-hp4rl 9 หลายเดือนก่อน

    Very Helpful. Can we arrange the columns in Correct order

  • @janajana6639
    @janajana6639 ปีที่แล้ว

    this is very helpful ..but i have one doubt why month name came irregular order in this output? pls clarify me

  • @nandhakumar7088
    @nandhakumar7088 2 ปีที่แล้ว

    How to rearrange the column months as order? Can we do that?

  • @aadarshchaudhari3957
    @aadarshchaudhari3957 ปีที่แล้ว +1

    Thanks sir

  • @CaribouDataScience
    @CaribouDataScience 3 ปีที่แล้ว

    That was interesting. How can I get the months listed in order?

    • @sobreinakentish8164
      @sobreinakentish8164 ปีที่แล้ว +2

      Pivot table accepts order by so just add at the end of the pivot table.

  • @kamskamundu6720
    @kamskamundu6720 3 ปีที่แล้ว

    Hello happy for your video. But i Want to get opennning balance with pivot . Can you help me

  • @nihalkumar7721
    @nihalkumar7721 4 ปีที่แล้ว

    How to pivot multiple column in Microsoft SQL server

  • @karthikeyant1549
    @karthikeyant1549 4 ปีที่แล้ว

    This is tutorial is awesome but to get not null values

  • @alwayschandra
    @alwayschandra 4 ปีที่แล้ว

    How to pass a single month in dynamic query rather than passing all months.

  • @arpitapatel8776
    @arpitapatel8776 5 ปีที่แล้ว

    Unable to download video please do needful

    • @Training2SQLMSBI
      @Training2SQLMSBI  5 ปีที่แล้ว

      Not sure on download part .. Pls watch on live and provide your feedback..

    • @arpitapatel8776
      @arpitapatel8776 5 ปีที่แล้ว

      @@Training2SQLMSBI your other video gets download but recently 4-5 videos there was same downloading problem. That's why I comments you sir