Similar to rows-to-col(EAV to relational) - SQL query please, contd

This question is related to:

Similar to rows-to-col(EAV to relational) - SQL query please

As suggested in that forum we are in the process of restructuring the schema. But as we have to support existing app, I would like to ask another related question:

Data is in the following format:

And I need in following format:

PROD_QTY is not involved now. PROD_KEY need to be placed in their respective column based on EN_NO as shown above. Tried out GROUP BY with CASE but to no avail. Suggestions??

Thanks,

Answers


If your using oracle 11g then pivot may be of some use: http://www.oracle.com/technetwork/articles/sql/11g-pivot-097235.html


Need Your Help

Performance of creating a C++ std::string from an input iterator

c++ string stream

I'm doing something really simple: slurping an entire text file from disk into a std::string. My current code basically does this:

How to display Images from internet in a windows phone 7 app?

c# silverlight windows-phone-7

I am making an application which gets urls of images by parsing an RSS feed.I want to diplay that images in the application one after another when tapped on screen .How can i do it? Is it required to

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.