Dynamic Columns

Hi all again,
I need an output like :
|--|--|--|--|--|
|row1|row2|row3|...|row(n)|
|--|--|--|--|--|

is possible to create output like that, without querying manually
cause too many dynamic columns in my application.
sorry if my question a bit weird cause i'm a newbie in MSSQL.

Cheers.aCe wrote:

Quote:

Originally Posted by

I need an output like :
|--|--|--|--|--|
|row1|row2|row3|...|row(n)|
|--|--|--|--|--|

I recommend you return normal data (where the rows are, y'know, rows)
from your database layer, then rearrange them in your reporting
layer. (If you don't have a reporting layer, then I recommend you
add one; I like Crystal Reports, myself.)