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.
| Author |
Topic |
|
sandsingh
Starting Member
11 Posts |
 Posted - 2010-03-30 : 07:52:58
|
| Table Name: BufTableStructure/Data:UserID CategoryU1 Category AU1 Category AU1 Category CU2 Category AU2 Category CU2 Category DU3 Category AU3 Category CU3 Category DDesired Result:UserID Count of Category A Count of Category B Count of Category C Count of Category DU1 2 0 1 0 etc.Help! |
|
|
PackRat
Starting Member
26 Posts |
Posted - 2010-03-31 : 14:45:44
|
| found this; not sure it's 100%, but ought to get you closer[url]http://www.blueclaw-db.com/report_dynamic_crosstab_field.htm[/url]_____________________________wrote this on my TRS-80 COCO4<PakRat/> |
 |
|
|
|
|
|
Conditional Count