Thanks people i will try to use temp tables and get back with the results.

Guru

thanks david and jxflagg..

This is a SCM database. The development model is COM. I am developing the purchase as well as subcontracting cycle.

So my procedures have to deal with both...

thanks david and jxflagg..

This is a SCM database. The development model is COM. I am developing the purchase as well as subcontracting cycle.

So my procedures have to deal with both...

thanks mice for the reply.

your solution is fine . but in my case

i have some views in the from clause that may or may not be there. so...