SQL query needed !! - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

SQL query needed !!

srivatsahgsrivatsahg Posts: 1Member
Hello Programmers..
I need a sql query similar to PIVOT transformation.
I have a table containing 3 Columns ...

[code]
STEP | Label | Value
--------------------
1 | Good | Enabled
2 | Better| Enabled
3 | Best | Disabled
[/code]

I need a sql query to get the results as

[code]
STEP | Good | Better | Best
--------------------------------------------
1 | Enabled | NULL | NULL
2 | NULL | Enabled | NULL
3 | NULL | NULL | Disabled
[/code]

Looks the query needs to display the transpose of a matrix
Any help in this direction appreciated

Srivatsa
Sign In or Register to comment.