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 |
|
shezad
Starting Member
32 Posts |
 Posted - 2007-02-21 : 01:46:20
|
| please solve this queryfirst table ============= second tableloginname ============= categoryidcategoryid ============= categorynamefirst table datanisar=====1,2,3,4)second table data1==== Bearbase2==== Amunation3==== Training 4==== WorkorderNow I want cross tab report like that which will show user name nisar has this category Nisar ==bearbase=== amunation === traiaing === workorder |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
|
|
|
please solve this query