no much familiar.....can just give me some pseudo code...so that i can develop further...

No Roy i cant do what you suggested....bcoz there is lot of joins and logic happening inside the function...

I just have to pass the parameters and union all those result...

Hey thx for your instant response. I have to check this solutions on my DB now.