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 |
|
patrickjao
Starting Member
24 Posts |
 Posted - 2012-08-05 : 05:14:14
|
| I have table as follow:Type Qty PriceABCD 100 20000BCDE 200 10000DEFG 500 30000ABCD 200 40000DEFG 600 50000HOW TO CREATE THE SUMIF COLUMN AS FOLLOW :Type Qty Price TQty TpriceABCD 100 20000 300 60000ABCD 200 40000 300 60000BCDE 200 10000 200 10000DEFG 500 30000 1100 80000DEFG 600 50000 1100 80000Thanks |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2012-08-05 : 07:17:38
|
| CREATE TABLE #SumIf (TType VARCHAR(10) ,Qty INT, Price INT)INSERT INTO #SumIf SELECT 'ABCD', 100, 20000 UNION ALLSELECT 'BCDE', 200, 10000 UNION ALLSELECT 'DEFG', 500, 30000 UNION ALLSELECT 'ABCD', 200, 40000 UNION ALLSELECT 'DEFG', 600, 50000SELECT TType ,Qty, Price, SUM(Qty) OVER (Partition By TType) QtySum ,SUM(Price) OVER (Partition By TType) PriceSum FROM #SumIfDROP TABLE #SumIf--------------------------http://connectsql.blogspot.com/ |
 |
|
|
|
|
|
|
|
SUMIF