@chris-2 Hurlbut:
Great stuff, just one function and it returns correct result. Awesome. Thanks!

@Jorge E P:
Thank you for posting this great script!
BIG help. Worked as designed.

Luis,

Thank you for the reply.

There is no issue with using word Length in there, it was that (-1) value of the @Length variable, which has caused wrong results to be...

Hi Luis,

here is the script which returns results as you've posted it:

IF object_id('tempdb..#Decimals', 'U') IS NOT NULL

DROP TABLE #Decimals;

CREATE TABLE #Decimals

(

...

Hi Luis,

RE: "Simulating CEILING and FLOOR with different lengths"

The following did not return expected results (i.e. the results you provided in your article).

IF object_id('tempdb..#Decimals', 'U') IS NOT NULL

...

Sorry folks in advance, but I've tried to find a thread with something more close to the question I have, yet I've not.

So, here it goes...

I created a SQL Alert...