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))

3
Contributors
2
Replies
15
Views
2 Months
Discussion Span
Last Post by Vijay_32
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.