0

+----------+----------+----------+
| WORKFLOW | ACCEPTED | REJECTED |
+----------+----------+----------+
| A        |        1 |        1 |
| B        |        1 |        1 |
| C        |        1 |        0 |
+----------+----------+----------+

I have tried to convert the following data

+------------------------------+
| |  ID | WORKFLOW | STATUS  | |
| +--------------------------+ |
| | 1  | A        | Approved | |
| | 2  | A        | Rejected | |
| | 3  | B        | Approved | |
| | 4  | B        | Rejected | |
| | 5  | C        | Approved | |
| +--------------------------+ |

INTO this

+------------------------------------+
| | WORKFLOW | ACCEPTED | REJECTED | |
| +----------+----------+----------+ |
| | A        |        1 |        1 | |
| | B        |        1 |        1 | |
| | C        |        1 |        0 | |
| +----------+----------+----------+ |

But I can't figure how to do it using pivot/unpivot.

Joshua Lan
  • 1
  • 1
  • 4
  • the answer given was only limited to single row. How do I able to have count on Accepted and Rejected for each workflow? – Joshua Lan Feb 08 '17 at 10:49
  • Already figured it out. The sql should look like this. SELECT * FROM ( SELECT WORKFLOW_NAME, STATUS FROM [workflow_table] )d PIVOT (COUNT(STATUS) FOR STATUS IN ([Approved],[Rejected]) )pvt – Joshua Lan Feb 08 '17 at 10:57

0 Answers0