Suggestions Needed to generate a matrix report

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

SQL Server 2008 Forums

Transact-SQL (2008)

Suggestions Needed to generate a matrix report

Author

Topic

Deep23
Starting Member

1 Post

Posted - 2011-10-13 : 00:04:30

Hi,

I am trying to generate this report.

Here is what I need:
A B C D
A 2 1 0 2
B 1 1 1 2
C 1 5 4 0
D 3 3 2 3

this is the table I have got:
ID Category
1 A
2 B
3 C
4 A
5 B
6 C
7 D

Any Suggestions on how I can approach this?

Thank you.

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2011-10-13 : 00:19:23

can you explain how do you get those numbers ?


Here is what I need:
  A B C D
A 2 1 0 2
B 1 1 1 2
C 1 5 4 0
D 3 3 2 3

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources