I think this is a error typo is this query: , oh.,oh.OrderDate

SELECT CustomerID,

COALESCE(oh.OrderCompleteDate, oh.OrderProcessDate, oh.OrderUpdatedDate, oh.OrderReceivedDate, oh.,oh.OrderDate) AS 'OrderDate'

FROM dbo.OrderHeader AS oh;