Submit My Question - Recent Questions - Recent Answer

Display Row Data As Cols

I have data in rows that I need to aggregate and display in a columnar fashion and I haven't been able to figure out how to do it. A simplified version of the data as it is stored in the table:

Station Month Day Reading

1 1 1 100

1 1 2 200

1 1 3 300

1 2 1 400

1 2 2 500

And I would like to create a query that returns:

Station Month Day 1 Day 2 Day 3

1 1 100 200 300

1 2 400 500

Any help you can provide or tips to steer me in the right direction are much appreciated.

Dianne Siebold

[576 byte] By [DianneSiebold] at [2007-12-21]

«« Transfering data from a textbox in one file to a textbox in another file
»» form not repainting text

# 1

Are you looking for something like this?

http://msdn2.microsoft.com/en-us/library/ms177410.aspx

AndreasJohansson at 2007-9-10 >

top of Msdn Tech,SQL Server,Transact-SQL...

# 2

That is very cool. I'm using SQL Server 2005 but I need to maintain query compatibility with Oracle so I'm looking for something that uses joins or maybe case statements to make it more portable.

DianneSiebold at 2007-9-10 >

# 3

Then maybe the responses in this thread might be helpful for you

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=438605&SiteID=1

Starting from the second reply by limno.

AndreasJohansson at 2007-9-10 >

# 4

I'm working on using that query logic but I'm just not getting how I can apply it to my query. I'll let you now if I have any success. Thanks!

DianneSiebold at 2007-9-10 >

# 5

I think I got it. I was able to take the concepts from the thread you referred me to and use them in another query. Thanks!

DianneSiebold at 2007-9-10 >

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech