2
Answers

Pivot more than one columns in SQL

Photo of Shahbaz Khan

Shahbaz Khan

7y
916
1
Here is my Orignal table
 
 
Now i need in this format defined below ...using PIVOT 
 
RefCode | Dates | Ratio | Profit |  Dates | Ratio | Profit | Dates | Ratio | Profit | .........
 
i have do it but it just prints like this  
 
RefCode | Dates | Ratio | Profit  only

Answers (2)