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 |
|
ksimpson
Starting Member
1 Post |
 Posted - 2014-08-07 : 17:27:06
|
| I am trying to multiply 2 columns and filtered by a 3rd but havent had any luck. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-08-07 : 17:29:35
|
| Please post your question like this: http://www.sqlservercentral.com/articles/Best+Practices/61537/Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2014-08-08 : 10:44:02
|
[code]select Price * SalesTax as AdjustedPricefrom MyTablewhere State = 'CA'[/code]??? (Not clear what you mean by "filtered")
Too often we enjoy the comfort of opinion without the discomfort of thought. - John F. Kennedy |
|
|
|
Chris_Kelley
Posting Yak Master
114 Posts |
Posted - 2014-08-09 : 10:53:45
|
| Do you mean GROUP BY? If so the GROUP BY column does not need to be included in the SELECT statement.Thanks,ChrisJr Programmer |
|
|
|
|
|
|
Multiplying 2 columns and filtered by a 3rd