471,075 Members | 1,121 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,075 software developers and data experts.

Sql Query with one column as the name to another column

Hi There

Does anyone know how to create a query or do something in a stored
procedure to output one column as the other columns name? The output I
want is something like this:

CurrentMonth(Jun 05) May 05 April 05
ItemCode Units Price Units Price Units Price

A 10 10.00 5 8.00 12 12.00

The month displayed as the column names will be in fields
CurrentMonthDesc, SalesHistoryDesc1, SalesHistoryDesc2 etc. Now I want
these to be the headings to Current, SalesHistory1, SalesHistory2 etc.

Please help!

Kind Regards
Marlene

Jul 23 '05 #1
0 1007

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

9 posts views Thread by netpurpose | last post: by
3 posts views Thread by Matthew Kramer | last post: by
4 posts views Thread by Judy | last post: by
4 posts views Thread by Captain Jack Sparrow | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.