Viewing 6 posts - 1 through 6 (of 6 total)
@Chris Hurlbut:Great stuff, just one function and it returns correct result. Awesome. Thanks!
March 11, 2019 at 3:18 pm
@Jorge E P: Thank you for posting this great script! BIG help. Worked as designed.
March 11, 2019 at 3:03 pm
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...
September 23, 2016 at 9:19 am
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
September 23, 2016 at 8:49 am
RE: "Simulating CEILING and FLOOR with different lengths"
The following did not return expected results (i.e. the results you provided in your article).
September 23, 2016 at 7:55 am
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...
April 27, 2016 at 2:27 pm