SQL query needed !!

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.

Howdy, Stranger!

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

Categories