Select and Insert 1

[AshleyRickards]

How can I take a field in one table that has multiple values and Insert it into a new table so I have a single record for each value. I'm selecting from multiple tables and creating a new table with the data but need an individual record. So if the host table has bob, john, tim in field1 the destination would have a one record for bob .. john etc.

TIA

Ashley L Rickards
SQL DBA

 

[SQLSister]

The following two FAQS may help you:
Passing a list of values to a Stored Procedure faq183-3979
Passing a list of values to a Stored Procedure (Part II) faq183-5207


Questions about posting. See faq183-874
Click here to learn Ways to help with Tsunami Relief