Thnx peter you are abs rite, column has no name, error was coz of select 1/0 statement, and yup now i m getting same problem that u have mentioned with BIDS when it invloves temporary tables it returns no cloumns.

I m working on this, if you get any scuess to get hold on this problem without changing SP plz reply me on this forum.

Thanks once again for ur feedback n help.