Thank you so much everyone.

I appreciate everyone's help.

Regards

Shubhra

Thanks for your reply, commenting these two rows is not giving me blank data set.

SET ROWCOUNT 1

SELECT @@rowcount

Now I have to figure out some other way to eliminate the...

Thanks for the prompt reply.

There are 2 selects but data is going in temp table so I think(I might be wrong) it should not diplay anything.

Here is the script:

ALTER PROCEDURE...