|
Comments
|
Mohamed Irshad on
11/21/2010
The "watch video now" in the below link is not opening the video. http://www.sqlshare.com/UsingtheTSQLMathOperators_854.aspx
|
|
Michael Miller on
11/22/2010
Author mentioned that the order of operation was Multiplication, Division, Addition, and Subtraction. He failed to mention that Multiplication and Division are equal in regards to order of precedence as are Addition and Subtraction and that evaluation is from left to right. It seems to be insinuated from the tutorial that Multiplication takes precedence over Division and Addition over subtraction, which is not the case.
|
|
Dennis Allen on
11/22/2010
Another common usage of the % operator is in base conversion functions.
|
|
|
Nice
|
|
|
Nice
|
|
|
Bringing back the basics. Good job, Andy.
|
|
Jamshid Nouri on
11/22/2010
excellent demo of math operation
|
|
Don Nesbitt on
11/22/2010
Good review...easy if you know how to do it.
|
|
|
Great for beginners
|
|
James Brown on
11/22/2010
good succinct beginner tutorial
|
|
Joaquin Ortega on
11/22/2010
Include Div/ZERO handling
|
|
Camilo prado on
11/22/2010
very helpful Tuto.
|
|
|
select 7/2.0 returns the decimal without the big ol convert function
|
|
Michael Sidley on
11/22/2010
Well done but would have been nice if you addressed null values in source data
|
|
|
Nice One
|
|
|
Nice One
|
|
|
Nice One
|
|
|
Nice One
|
|
|
Nice One
|
|
|
Nice One
|
|
|
Multiplication and division are equal operators and are interchangeable
select 5 * 4 / 2 - 1 + 9
select 4 / 2 * 5 - 1 + 9
Yield the same while forcing multiplication first
select 4 / (2 * 5) - 1 + 9
does not
|
|
|
Excellent SSRS example! Thanks Andy.
|
|
Mohamed Irshad on
11/25/2010
very nice
|
|
|
Useful, only order of operators not, because it is as expected
|
|
|
I found alot of this information very useful.
|