Viewing 15 posts - 31 through 45 (of 156 total)
Hugo Kornelis (8/24/2010)
paul.knibbs (8/24/2010)
Nope, just tested it on a SQL 2008 Express install and it came up with an arithmetic overflow as expected.
Super! Thanks for testing and reporting back here.
Obviously,...
August 24, 2010 at 10:53 pm
hrvoje.piasevoli (8/24/2010)
Hugo Kornelis (8/24/2010)
Here is an interesting experiment (works on every client):
SELECT ROUND(789.98,-3) AS WeirdColINTO WeirdTable;
go
EXEC sp_help 'WeirdTable';
go
UPDATE WeirdTable
SET WeirdCol = WeirdCol - 0.001;
go
DROP TABLE WeirdTable;
go
Hugo what is the expected...
August 24, 2010 at 5:48 am
Hugo Kornelis (8/24/2010)
ziangij (8/23/2010)
for
select ROUND(748.58, -3)
result displayed is 1000.00
but when i execute the same i get an error:
An error occurred while executing batch. Error message is:...
August 24, 2010 at 5:45 am
plz. refer http://technet.microsoft.com/en-us/library/ms175003.aspx
for
select ROUND(748.58, -3)
result displayed is 1000.00
but when i execute the same i get an error:
An error occurred while executing batch. Error message is: Arithmetic Overflow.
any suggestions...
August 23, 2010 at 10:54 pm
good one... duplicates can only be avoided by having a constraint in place...
August 15, 2010 at 11:06 pm
thanks 🙂
was always worried about such integer conversions... will now just add a dot to ensure that the conversion is correct...
August 10, 2010 at 12:25 am
thanks... will do the required changes and get back with the updates...
Jack Corbett (8/5/2010)
August 5, 2010 at 11:10 am
yep... the 12 datasets bring in different data values...
August 4, 2010 at 11:47 pm
even this works...
set @result = round(cast(5 as float) / 3,1)
i guess either the numerator or denominator should be in the proper format.
cengland0 (8/3/2010)
August 3, 2010 at 3:33 am
Viewing 15 posts - 31 through 45 (of 156 total)