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.

Re: Dynamic Columns

aCe wrote:

> 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.)