SQL Sybase - Convert Rows to Columns
Posted on 2013-12-02
I have a numerical result for each month in the Current table. Each result is a row. I
I would like to be able to create a result set, so that the months are columns and all the relevant monthly values are in the relevant month column in one row see Target table structure (below)
Current Table Structure:
ID Month Result
1 02 9.7
2 03 6.5
3 01 3.2
Target Table Structure:
ID Jan Feb Mar
1 3.2 9.7 6.5
Can anyone give me complete answer that I can simply paste in and adapt? BTW, I am a novice at SQL.
PS Not all the MS SQL commands like PIVOT are available in Sybase.