Cross Tab Querry Help
-
Monday, December 17, 2012 2:32 PM
I have a small database for out fantasy baseball league. I have a table that will give contains the team_id for each pick in each round. I want to have a matrix for picks accross the top and round on the side so you can see what team is in each
pick 1 pick 2 pick 3
Round 1 atl lad bal
Round 2 lad nat lad
It would be the team id's above but thought it would make more sense for you to see the team name for example. The fields are all named team_owner, round, pick for the query but I cant seem to figure out how to put together as most of the web examples are aggregate and I simply want to show the value for when the two intersect.
Thanks,
Bill
All Replies
-
Monday, December 17, 2012 5:56 PM
Hi,
See below hope it will help you:
http://msdn.microsoft.com/en-us/library/ms177410(v=sql.105).aspx
Ahsan Kabir Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread. http://www.aktechforum.blogspot.com/
-
Monday, December 17, 2012 6:07 PMI have been looking at that article but what keeps throwing me is in each example they are using aggregates and I cant wrap my little brain around how to just display the data.
.png)
