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 |
|
Asteroid
Starting Member
13 Posts |
 Posted - 2005-07-01 : 09:55:38
|
| Hi,I am stuck up i a problem. My Table looks like this..ID Amount ------ -------1------ 1002------ 1003------ 200 4------ 1005------ 5002------ 2001------ 2001------ 2004------ 1001------ 5005------ 1005------ 100And I need the results like this. The result is just like sumary of the number of different amountsLike if the amount how many times ID 1 has used amount 100 and how many times amount 200 and so on for all the IDs. Some thing like this....ID Count_100 Count_200 Count_500 -- ---------- --------- ----------1---------2-----------2------------12---------1-----------1------------ 3---------1----------- 4---------1-----------1 5---------2-----------1 Any Solution ,, Please help |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Cross Tab Queries Summarisig the data in coulmns