title: unpivot result from temporary table
body: <p>i try to get the result in an unpivot resultset but with more column I've never used this technique.</p>
  
  <p>I got a temporary table.. with many field... but focus on listing below.</p>
  
  <pre><code>SELECT 
      u.IDNode_u,
      l.lev_u
  from #Slugs
  unpivot
  (
    IDNode_u  for node       in (IDNodo, IDNodoPadre, [IDNodoPadre-2], [IDNodoPadre-3], [IDNodoPadre-4], [IDNodoPadre-5], [IDNodoPadre-6])
  ) u
  unpivot
  (
    lev_u   for level   in (LivelloTop, [LivelloTop-1], [LivelloTop-2], [LivelloTop-3], [LivelloTop-4], [LivelloTop-5], [LivelloTop-6])
  ) l
  </code></pre>
  
  <p>The query is ok only with the first unpivot, with second add I got error:
  "The multi-part identifier "u.IDNodo_u" could not be bound.", but I think is bound to the second unpivot.</p>
  
  <p>Can someone with me some advise?
  Alen Italy.</p>