I have one more question regarding this..

Can we store the result set in a view.

If yes how and when will the temp table is dropped.

Please help.

Thank you,

Sravan