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 |
|
gomo
Starting Member
4 Posts |
 Posted - 2011-07-21 : 14:27:56
|
Hi,
I want to sum a number of colums but also show distinct parts, i.e.
Part no qty net value
123 1 10
456 5 80
123 10 60
so i would like to achieve
Part no qty net value
123 11 70
456 5 80
thanks for your help
mo
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-07-21 : 14:57:28
|
Duplicate post. No replies to this thread please. Direct replies to:[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=163357[/url]
--
Gail Shaw
SQL Server MVP |
 |
|
|
|
|
|
sum many columns