0

When i run the statement below i am getting a number of xxx.xxxx can anyone help me change this to two DP?

(SELECT sum(oht_net) FROM order_header_total
JOIN order_header ON oh_id = oht_oh_id
WHERE oh_cd_id = cd_id AND oh_sot_id = 1 AND DATEPART(yyyy, oh_datetime) = (SELECT DATEPART(yyyy, GETDATE()) -1))

2
Contributors
1
Reply
7
Views
4 Days
Discussion Span
Last Post by rproffitt
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.