GSquared... thanks for the explanation. i'm trying it out actually.

and... the results are in!

GSquared; you are much smarter than i am 🙂

it worked great... reeeaaalllyyy...

i think i'm causing some confusion. i'll try to clear things up a bit.

i have a column full of numeric values. the column datatype is decimal (25,10)

if...

thanks for the quick feedback.

perhaps i don't understand this yet in it's entirety:

"The CEILING function returns the smallest integer greater than or equal to the specified numeric expression. The FLOOR...

Adam,

Thats some class... Worked better and 30 minutes faster than any solution I

could put together.

Thanks 🙂

well.. prior to all this my first attempt was to change the datatype

from float to decimal (25,10) however couldn't get passed the arithmetic

overflow error. not only from gui,...

Adam, Thanks my friend.

So now; I can see the values both Decimal, and Float,

and it got through no problem. I'm so used to seeing errors,

that I'm amazed...

Wow... It's unreal to how knowledgeable you guys are in this stuff.

I'm looking into the former script to see If I can get it to run properly.

I'm getting a declaration...

thanks for the feedback on that, but doesn't

this do the same thing?

update myTable

set myCol = round(myCol, 10, 1)

Ian,

all failed with the same error. i want to try something like duplicating the

table, then run an import but transform the data on the way over to the...

added the new precision no problem,

then truncated using round(mycolumn, 10, 1) no problem.

then changed the datatype to Decimal (25, 10) using

the alter table - alter column command, and... after

a long...

it's interesting that you posted information about the 'round' function. i

was already running a few tests with it and was about to ask about using 'round' in a

conversion...

i tried the GUI first thing when trying to convert the

datatype from float to decimal (25,10)

it errored out with the following in just about a minute:

"Arithmetic overflow error converting...

ahh well... it was a pretty good run.

still get this error though:

Msg 8115, Level 16, State 6, Line 1

Arithmetic overflow error converting float to data type numeric.

i think cause there...

adam... thanks for the samples

so far so good.... running past a couple million rows, and no issues...

i'll post an update when it's finished.

again... thanks 🙂

first... thanks for all the good feedback. it's really appreciated.

the conversion that i did was using the gui. where you right click the table (FinMain), and

select 'design' ...