@joenobk For you, sure. And in that setup, it could also be recursive, if you’d like.
Without looking it up, and for the first time in my life, I wrote the correct T-SQL syntax for UNPIVOT today.
AMA
August 26th, 2020
- Recent tweets
- Favorites
- January 2023 4
- December 2022 4
- November 2022 5
- October 2022 10
- September 2022 8
- August 2022 9
- July 2022 12
- June 2022 8
- May 2022 8
- April 2022 26
- March 2022 10
- February 2022 4
- January 2022 11
- December 2021 11
- November 2021 8
- October 2021 5
- September 2021 3
- August 2021 19
- July 2021 12
- June 2021 21
- May 2021 8
- April 2021 11
- March 2021 11
- February 2021 10
- January 2021 31
- December 2020 7
- November 2020 20
- October 2020 12
- September 2020 7
- August 2020 8
- July 2020 19
- June 2020 27
- May 2020 18
- April 2020 27
- March 2020 21
- February 2020 7
- January 2020 13
- December 2019 22
- November 2019 20
- October 2019 28
- September 2019 42
- August 2019 22
- July 2019 28
- June 2019 18
- May 2019 23
- April 2019 15
- March 2019 28
- February 2019 23
- January 2019 39
- December 2018 9
- November 2018 8
- October 2018 23
- September 2018 15
- August 2018 31
- July 2018 12
- June 2018 30
- May 2018 32
- April 2018 39
- March 2018 29
- February 2018 28
- January 2018 41
- December 2017 23
- November 2017 64
- October 2017 27
- September 2017 30
- August 2017 20
- July 2017 24
- June 2017 20
- May 2017 30
- April 2017 19
- March 2017 32
- February 2017 16
- January 2017 28
- December 2016 19
- November 2016 22
- October 2016 50
- September 2016 28
- August 2016 54
- July 2016 29
- June 2016 110
- May 2016 30
- April 2016 49
- March 2016 37
- February 2016 21
- January 2016 15
- December 2015 34
- November 2015 74
- October 2015 59
- September 2015 18
- August 2015 22
- July 2015 17
- June 2015 22
- May 2015 24
- April 2015 18
- March 2015 30
- February 2015 21
- January 2015 25
- December 2014 17
- November 2014 37
- October 2014 28
- September 2014 60
- August 2014 38
- July 2014 26
- June 2014 41
- May 2014 32
- April 2014 34
- March 2014 29
- February 2014 32
- January 2014 33
- December 2013 26
- November 2013 34
- October 2013 21
- September 2013 39
- August 2013 29
- July 2013 50
- June 2013 44
- May 2013 41
- April 2013 36
- March 2013 49
- February 2013 26
- January 2013 42
- December 2012 29
- November 2012 35
- October 2012 38
- September 2012 40
- August 2012 46
- July 2012 51
- June 2012 22
- May 2012 58
- April 2012 43
- March 2012 40
- February 2012 33
- January 2012 36
- December 2011 34
- November 2011 33
- October 2011 31
- September 2011 33
- August 2011 24
- July 2011 27
- June 2011 36
- May 2011 41
- April 2011 45
- March 2011 30
- February 2011 19
- January 2011 25
- December 2010 21
- November 2010 26
- October 2010 23
- September 2010 33
- August 2010 25
- July 2010 19
- June 2010 22
- May 2010 32
- April 2010 36
- March 2010 42
- February 2010 35
- January 2010 53
- December 2009 37
- November 2009 33
- October 2009 30
- September 2009 34
- August 2009 44
- July 2009 48
- June 2009 54
- May 2009 58
- April 2009 52
- March 2009 35
- February 2009 30
- January 2009 42
- December 2008 37
- November 2008 34
- October 2008 42
- September 2008 57
- August 2008 67
- July 2008 49
- June 2008 49
- May 2008 62
- April 2008 43
- March 2008 32
- February 2008 25
- January 2008 34
- December 2007 17
- November 2007 24
- October 2007 29
- September 2007 36
- August 2007 21
- July 2007 16