sql server 1 user many phones in a tmp folder
===

  I need to show in a temporary table one user a many phone of that user, but I'm stuck
  in   the select, I need something like this:

  user1        phone1   phone2    phone3   phone4  phone5
  11816116-5   8555588  77877888  33254477 224474  45777885
  
  this is the code that I'm trying:

  select  phone As phonenum Into #Tmp_phonenumber From 
                  clients_has_phones where user_number='11816116-5'

  thanks in advance.