Dynamic Columns
This is a discussion on Dynamic Columns within the SQL Server forums, part of the Microsoft SQL Server category; --> Hi all again, I need an output like : |----|----|----|---|------| |row1|row2|row3|...|row(n)| |----|----|----|---|------| is possible to create output like that, ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
03-01-2008, 03:40 PM
| ||||
| ||||
 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.      |
|
03-01-2008, 03:40 PM
| ||||
| ||||
| 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.) |
Linear Mode
