Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT TOP 5
- (applied_network_coefficient_r * applied_ppp_factor * applied_attractiveness_coefficient) as actual_step2_result,
- SQL_VARIANT_PROPERTY(applied_network_coefficient_r * applied_ppp_factor * applied_attractiveness_coefficient, 'Precision') as actual_step2_precision,
- SQL_VARIANT_PROPERTY(applied_network_coefficient_r * applied_ppp_factor * applied_attractiveness_coefficient, 'Scale') as actual_step2_scale,
- applied_network_coefficient_r,
- applied_ppp_factor,
- applied_attractiveness_coefficient,
- CAST((CAST((applied_network_coefficient_r * applied_ppp_factor) AS DECIMAL(28, 18)) * applied_attractiveness_coefficient) AS DECIMAL(28, 18)) as corrected_step2_result,
- SQL_VARIANT_PROPERTY(CAST((CAST((applied_network_coefficient_r * applied_ppp_factor) AS DECIMAL(28, 18)) * applied_attractiveness_coefficient) AS DECIMAL(28, 18)), 'Precision') as corrected_step2_precision,
- SQL_VARIANT_PROPERTY(CAST((CAST((applied_network_coefficient_r * applied_ppp_factor) AS DECIMAL(28, 18)) * applied_attractiveness_coefficient) AS DECIMAL(28, 18)), 'Scale') as corrected_step2_scale
- FROM
- event.play
- WHERE
- applied_attractiveness_coefficient > 0.0;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement