Hi Chris,

Thanks, The query was working fine.

Actually i am trying the query in single statement without using UNION ALL.

So, because of that i could not able to get required output.

Once...