Display from vertical to horizontal

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Display from vertical to horizontal

Author

Topic

template
Starting Member

3 Posts

Posted - 2011-01-28 : 02:01:06

Hello Guys,

I think my post belongs here..
I'm new to sql programming. can you help me with this?

I have table like


Date     Quantity1  Quantity2   
1/1/11   1          4
1/2/11   2          5
1/3/11   3          6
....

and i want to display it like this in the report


Date            1/1/11      1/2/11     1/3/11 
Quantity1       1           2          3
Quantity2       4           5          6

*note the number of rows is dynamic and dates are unknown
what query or technique can i use? thanks in advance !

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2011-01-28 : 02:07:11

please do not cross post.

Continue on the original thread. http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=155869

KH
[spoiler]Time is always against us[/spoiler]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources