Hi all again,
I need an output like :
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:

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