After more experimenting it appears the I am having issues only when I try to UNION ALL the selects together. If I run them as separate Select statements then it appears to work fine. But this leaves me very confused as to why this is happening.

Nick