SQL code for "Stack" and "Split" JMP buttons

[#1]

Hi,

Does anyone have a SQL code equivalent for the "split" and "stack" options under JMP Tables menu?  Those are very slick and was wondering if there was someone that might know how to do those in SQL?

[#2 · Accepted solution]

I've done stuff with PIVOT/UNPIVOT in sql server. But it's always custom.  

[#3]

It's been a while but I remember this now. Thank you!