I was contacted by Eric Wu from Microsoft and provided my solution through an email to Eric. This is the text of the email. After doing some research, I figured it out. I used coalesce on the null ...