Ramakrishna-148487 (5/18/2014)

---

my procedure contains three four temporary tables and using without creation of table structure

for ex:

Select * into #td from transsactions

Transactions tables contains huge data. Like that i am using three temporary tables without creating the table structure.

while calling with procedure sometimes iam getting performance issues. execution getting delayed. it is working when i rename the procedure for some days.

Definitely not enough information to help. First thing I would do is read the second article I have linked in my signature block regarding performance issues. It will walk you through what you need to post and how to post it to get the best help possible for a performance problem.