Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations GregLocock on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need help splitting out columns for each row into new table

Status
Not open for further replies.

dba123

Computer
Dec 15, 2005
3
Let's say I do a select statement and the results are

Acct # Zip Phone Addr
11223 23232 333-444-5555 6556 Duns Rd.
12345 34343 222-444-3333 1000 Aspire Blvd.

I need to create a record using the Acct # and column for each column as well as append some other values like this

11223 23232 othervalue1 othervalue2
11223 333-444-5555 othervalue1 othervalue2
11223 6556 Duns Rd. othervalue1 othervalue2
12345 34343 othervalue1 othervalue2
12345 222-444-3333 othervalue1 othervalue2
12345 1000 Aspire Blvd. othervalue1 othervalue 2

How do I do this for each row in my result set?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor