TIL: Another Great Use Of APPLY

Yesterday, at DevTeach, I got to see Itzik Ben-Gan give a session on advanced T-SQL operations, mostly around gaps & islands but also including a couple other gems.  Something that caught my eye was an interesting way of using APPLY to unpivot data.  I know a few good uses of the APPLY operator and this was…