(Divide) (DMX)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Performs an arithmetic operation that divides one number by another number.

Syntax


Dividend / Divisor  

Parameters

Dividend
A valid Data Mining Extensions (DMX) expression that returns a numeric value.

Divisor
A valid DMX expression that returns a numeric value.

Return Value

A value that has the data type of the parameter that has the higher precedence.

Remarks

The value that this operator returns represents the quotient of the first expression divided by the second expression.

Both expressions must be of the same data type, or one expression must be able to be implicitly converted to the data type of the other expression. If the divisor evaluates to a null value, the operator raises an error. If both the divisor and the dividend evaluate to a null value, the operator returns a null value.

See Also

Arithmetic Operators (DMX)
Data Mining Extensions (DMX) Operator Reference
Operators (DMX)
Divide (SSIS Expression)
(Divide) (Transact-SQL)