Advertisement
Guest User

Untitled

a guest
Jun 17th, 2019
211
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 1.14 KB | None | 0 0
  1. SELECT TOP 5
  2.     (applied_network_coefficient_r * applied_ppp_factor * applied_attractiveness_coefficient) as actual_step2_result,
  3.     SQL_VARIANT_PROPERTY(applied_network_coefficient_r * applied_ppp_factor * applied_attractiveness_coefficient, 'Precision') as actual_step2_precision,
  4.     SQL_VARIANT_PROPERTY(applied_network_coefficient_r * applied_ppp_factor * applied_attractiveness_coefficient, 'Scale') as actual_step2_scale,
  5.     applied_network_coefficient_r,
  6.     applied_ppp_factor,
  7.     applied_attractiveness_coefficient,
  8.     CAST((CAST((applied_network_coefficient_r * applied_ppp_factor) AS DECIMAL(28, 18)) * applied_attractiveness_coefficient) AS DECIMAL(28, 18)) as corrected_step2_result,
  9.     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,
  10.     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
  11. FROM
  12.     event.play
  13. WHERE
  14.     applied_attractiveness_coefficient > 0.0;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement