Help in Insert into select from SQL

Originally Posted by OraMaster

Hi All

I have attached one insert into select from kind of SQL with this message and the procedure to which it belong. Now the problem is when i run this select SQL separately its giving result very fast (within 2 seconds) but when i execute procedure it's taking 3-4 miniutes. I am not figure out exactly where is the problem since I am new to SQL server. Please check the attachement and suggest me any improvment in SQL.

All three files along with execution plan are in .zip file.

Please let me know if you guys need more information on this.

Thanks in advance
Bhushan