UFN_RESOURCE_CALCULATEPERTICKETQUANTITY_2

Return

Return Type
int

Parameters

Parameter Parameter Type Mode Description
@DIVIDEND int IN
@DIVISOR int IN

Definition

Copy


create function dbo.UFN_RESOURCE_CALCULATEPERTICKETQUANTITY_2
(
    @DIVIDEND int,
    @DIVISOR int
)
returns int
as begin
    declare @QUANTITY float = @DIVIDEND / cast(@DIVISOR as float);
    declare @WHOLENUMBER int = @QUANTITY;
    declare @ADJUSTMENT int = case when @QUANTITY = @WHOLENUMBER then 0 else 1 end;

    return @WHOLENUMBER + @ADJUSTMENT;
end