Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2006
    Posts
    14

    Unanswered: normalize a table with 3 similar columns (was "Plz help out")

    Hi,I am working on SQL Server.
    I have a table with columns that need to be broken down. I nees to break this table:

    TelNo1 TelNo2 TelNo3

    555-44-33 555-43-88 555-46-89

    into:


    Tel_Number

    555-44-33
    555-43-88
    555-46-89

    I tried using the union statement but i just did'nt succed. Can anyone help me,please

  2. #2
    Join Date
    Nov 2003
    Posts
    2,933
    Provided Answers: 12
    It helps if you post the statements where you didn't "succeed". But anyway:
    Code:
    SELECT TelNo1 
    FROM theTable
    UNION 
    SELECT TelNo2
    FROM theTable
    UNION
    SELECT TelNo3
    FROM theTable

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •