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 |
|
mkswanson
Starting Member
21 Posts |
 Posted - 2013-02-08 : 05:06:24
|
| I have a table that contains info:id, date, amount, amountTypeamountType has 3 valid values (1, 2, 3)I would like to create a statement that returnsid, date, amount (where amount type = 1), amount (where amount type = 2) amount (where amount type = 3)In reality, the table and data are more complex, but I can't get the simpler scenario to work. This isn't really that difficult, is it?Thanks for any input... |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-02-08 : 05:19:19
|
| [code]SELECT *FROM table tPIVOT (SUM(amount) FOR amountType IN ([1],[2],[3]))p[/code]------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
JOIN HELP