Ranga, due to being so busy with my prior commitments to give your thread the attention it deserves I have aske Jimmy the Hand to have a look at it.
He has developed something similar to you and he is really great at SQL, so he should be able to sort out your union queries, so I would respond to his post if I was you.
He can learn some new things from your code I did and hopefully help you with the SQL side.