thanks
but i cant take table variable or temp table ? i need to use local variable .
but if atlast i go with local variable will there be performance difference between local variable and table variable ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)