Viewing 15 posts - 7,306 through 7,320 (of 19,564 total)
I preface this by saying that I have not used certifyweb or the study materials in the ebay link.
I am very leery of using any such material due to the...
January 3, 2012 at 11:18 pm
Jeff Moden (1/3/2012)
And it actually has more than 10 rows of test data. Nicely done, Jason.
Thanks Jeff
January 3, 2012 at 11:13 pm
Try this article on how to do it using a CTE.
January 3, 2012 at 10:51 pm
It's nice to be reminded of these things. I think I would prefer to not have the implied conversions though.
January 3, 2012 at 10:49 pm
crookj (1/3/2012)
Revenant (1/3/2012)
Brandie Tarvin (1/3/2012)
SQLRNNR (1/3/2012)
Ray K (1/3/2012)
SQLRNNR (1/3/2012)
reprievereprogram
Daemon
Domain
Model
T
Ford
January 3, 2012 at 1:19 pm
Ray K (1/3/2012)
SQLRNNR (1/3/2012)
reprievereprogram
Daemon
January 3, 2012 at 10:08 am
Glad you posted back with your findings.
January 3, 2012 at 10:06 am
SQL Kiwi (1/3/2012)
steven.malone (1/3/2012)
Very interesting.Declaring the decimal variables as DECIMAL(35,20) gives the correct result.
But declaring the decimal variables as DECIMAL(35,19) gives the rounded result.
Two DEC(35,20) multiplied gives a result of...
January 3, 2012 at 10:01 am
GilaMonster (1/3/2012)
Ninja's_RGR'us (1/3/2012)
GilaMonster (1/3/2012)
Ninja's_RGR'us (1/3/2012)
January 3, 2012 at 9:58 am
Ninja's_RGR'us (1/3/2012)
GilaMonster (1/3/2012)
Ninja's_RGR'us (1/3/2012)
January 3, 2012 at 9:57 am
No - do it for all of them. You will find that it will come back to save you someday if you audit all of them.
January 2, 2012 at 9:17 pm
Viewing 15 posts - 7,306 through 7,320 (of 19,564 total)