Cool - I'll try UNPIVOT - do you have a very simple example of this?

select * FROM table

UNPIVOT xxxx...

I tried getting PIVOT to work and never could get the syntax...

I'll try dynamically generating the SQL in a proc with the select commands that were proposed - Thanks!

Yup..data looks like this

- standard table format

col1 |col2 |col3

Row1 val1 |val2 |val3

Row2 val1 |val2 |val3

Row3 val1 |val2...

Guess this was tougher than I thought - no posts....

FYI - you can also execute any saved DTS or SSIS packages from the command line using DTSRUN.EXE

I forgot to add...if you use DTS/SSIS then you can save the job and just have it run on demand or at regular times...

Try going through the DTs import wizard...

FYI - your approach works in both DTS and SSIS and it is far easier to setup using these utilities than using a query however, you can use a query...

Does anyone know how to bring back the data in relational table format? (new report requirment)

Currently (with the above solution) I get:

name1 value1

...

namen valuen

How...

Excellent - you rock!!! That was exactly what I needed. I can now spend the next several days trying to figure out how it works....:)