Viewing 3 posts - 1 through 3 (of 3 total)
Today I found out what a SQL Inline Table Value Function is!
I can't understand how an iTVF would be easier to use, I have a calculation like s0:
September 16, 2023 at 3:13 am
I like this version better, because it does not have the magic constant "0.005" in it:
create function dbo.RoundToEven(@num numeric(38,19)) returns decimal(19,2)
begin
return case
when round(@num,...
September 16, 2023 at 2:48 am
@GrassHopper's solution does not work for negative numbers, so here's his version that does work for negative numbers:
create function dbo.RoundToEven(@num numeric(38,19)) returns decimal(19,2)
begin
return case
...
September 15, 2023 at 10:03 pm
Viewing 3 posts - 1 through 3 (of 3 total)