Live Reference SSMS Pivot Table Method

• jsanchezmlj

  SSC Rookie

  Points: 32

  More actions

  November 16, 2022 at 10:01 pm

  #4114044

  Is there any way to have any new data pivot out in SSMS without having to run an update or hard-code anything?  Essentially a living pivot table that is always going to select all columns for the pivot?

• Site Owners

  SSC Guru

  Points: 80381

  More actions

  November 17, 2022 at 10:10 pm

  #4114545

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• ratbak

  Default port

  Points: 1421

  More actions

  November 17, 2022 at 10:30 pm

  #4114554

  See https://www.sqlservercentral.com/articles/cross-tabs-and-pivots-part-1-converting-rows-to-columns-1 & https://www.sqlservercentral.com/articles/cross-tabs-and-pivots-part-2-dynamic-cross-tabs