If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Based on the WHERE Clause, the query runs perfectly! Our requirement is to change the column name as well. If the month is JAN should also display JAN, If FEB, then a column name should be FEB, instead no matter what query executes it always display the JAN (First column)

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Hi,
The query is self-described. If you run you will know my requirement.
Thanks.

You are asking for help and when we ask you for clarification, you are unwilling to do so???

What are you smoking?

Your query tells us what you have now. Obviously that does NOT satisfy the requirements or you wouldn't have a question to ask. So since it does NOT satisfy the requirements, how can we possibly glean the requirements FROM it??

My assumption is that what you are asking for is a rotated resultset, but unless you make the effort to at least meet us halfway, we will never know. Remember that it is *you* who came to *us* asking for help.