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 |
|
gagani
Posting Yak Master
112 Posts |
 Posted - 2012-01-12 : 11:22:53
|
| i have two tables table1:orderid netvalue101 1000102 2000103 3000table2:orderid percentage101 0.1102 0.1I want the output as follows:orderid net(netvalue- (netvalue*percentage))101 900102 1800103 3000please note that table2 dont have all orderids. so percentage is considered 0 for that particular orderid |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
query