By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,659 Members | 1,678 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,659 IT Pros & Developers. It's quick & easy.

Help in Insert into select from SQL

OraMaster
100+
P: 135
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
Attached Files
File Type: zip SQL server tasks.zip (11.7 KB, 54 views)
Sep 22 '09 #1
Share this Question
Share on Google+
1 Reply


OraMaster
100+
P: 135
@OraMaster
Hi All,

I have solved the issues wt my procedure. Thanks for those who atleast viewed my post :)

Regds,
Bhushan
Sep 22 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.