Hi,
How could I create a new table dynamically where columns names are data
from another table?

Example:
I have a table "Table1" with one column "T1Col"
The column contains following data:
"Row1"
"Row2"
"Row3"

Now I would like to "read" data from Table1 and create a new table
Table2 which will contain columns "Row1", "Row2" and
"Row3".

Any help will be appreciated.

Thank you in advance.

Google for "transpose" or "cross-tab" or search this newsgroup.


ML

---
http://milambda.blogspot.com/

Concatenating:www.aspfaq.com/show.asp?id=2529 Is the glass half full or half empty or..?
Query help - resultset too large... impossible!
Used Disk Space reporting and sending Email
Problem updating two tables in a transaction.
Query assistance or advice