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,pleaseIt helps if you post the statements where you didn't "succeed". But anyway:
SELECT TelNo1
FROM theTable
UNION
SELECT TelNo2
FROM theTable
UNION
SELECT TelNo3
FROM theTable

Noob Diving into DTS Packages

Is it possible to import a CSV and break the contents into multiple
tables?
On Apr 9, 3:59 pm, "JGiotta" <jdgio...@.gmail.com> wrote:
> Is it possible to import a CSV and break the contents into multiple
> tables?
Use a staging table for that
Denis the SQL Menace
http://sqlservercode.blogspot.com/
|||Thanks, I'll look into it.
Do you recommend any book that cover DTS well?
|||On Apr 9, 5:05 pm, "JGiotta" <jdgio...@.gmail.com> wrote:
> Thanks, I'll look into it.
> Do you recommend any book that cover DTS well?
Here is one I like
Professional SQL Server 2000 DTS (Data Transformation Services
by Mark Chaffin , Brian Knight , Todd Robinson
[url]http://www.amazon.com/gp/product/0764543687/102-5735017-0910517?ie=UTF8&tag=sql08-20&linkCode=xm2&camp=1789&creativeASIN=0764543687[ /url]
Denis the SQL Menace
http://sqlservercode.blogspot.com/
|||Thanks again

Noob Diving into DTS Packages

Is it possible to import a CSV and break the contents into multiple
tables?On Apr 9, 3:59 pm, "JGiotta" <jdgio...@.gmail.com> wrote:
> Is it possible to import a CSV and break the contents into multiple
> tables?
Use a staging table for that
Denis the SQL Menace
http://sqlservercode.blogspot.com/|||Thanks, I'll look into it.
Do you recommend any book that cover DTS well?|||On Apr 9, 5:05 pm, "JGiotta" <jdgio...@.gmail.com> wrote:
> Thanks, I'll look into it.
> Do you recommend any book that cover DTS well?
Here is one I like
Professional SQL Server 2000 DTS (Data Transformation Services
by Mark Chaffin , Brian Knight , Todd Robinson
http://www.amazon.com/gp/product/07...ASIN=0764543687
Denis the SQL Menace
http://sqlservercode.blogspot.com/|||Thanks again

Noob Diving into DTS Packages

Is it possible to import a CSV and break the contents into multiple
tables?On Apr 9, 3:59 pm, "JGiotta" <jdgio...@.gmail.com> wrote:
> Is it possible to import a CSV and break the contents into multiple
> tables?
Use a staging table for that
Denis the SQL Menace
http://sqlservercode.blogspot.com/|||Thanks, I'll look into it.
Do you recommend any book that cover DTS well?|||On Apr 9, 5:05 pm, "JGiotta" <jdgio...@.gmail.com> wrote:
> Thanks, I'll look into it.
> Do you recommend any book that cover DTS well?
Here is one I like
Professional SQL Server 2000 DTS (Data Transformation Services
by Mark Chaffin , Brian Knight , Todd Robinson
http://www.amazon.com/gp/product/0764543687/102-5735017-0910517?ie=UTF8&tag=sql08-20&linkCode=xm2&camp=1789&creativeASIN=0764543687
Denis the SQL Menace
http://sqlservercode.blogspot.com/|||Thanks again