Home Forums SQL Server 2008 T-SQL (SS2K8) Possible to vary column names in cross apply based on different columns in each table? RE: Possible to vary column names in cross apply based on different columns in each table?

  • Looking at your example more closely, we would also need a way to tell which columns we are unpivoting together (what is a value vs rank, what value belongs with what rank, what name to give, and how to reliably tell them apart).