Edited : Added Florian's worship!

Try this, see what it does for you, tell me if it's any better.

Couldn't find my piece of code so I "Stole" Florian's, I hope he...

dndaughtery (3/26/2009)

---

I am running an insert where I'm performing an inner join between two large tables (13 million rows in each). I looked in the Activity Monitor and the process...

Thanks Mike, these are some really interesting thoughts for some new development. The thing is, we still have to keep the "old" data, that is denormalized in the tables, for...

Damn, Gift beat me to it, 😀

You could add an identity column, set identity insert on, and update to get the same value of your "Current ID" Column, then drop your column. You would then have...

Mike, do not cross post, that is useless and only fragments answers.

Future posts should be posted here

http://www.sqlservercentral.com/Forums/Topic683505-338-1.aspx

Lol, good job Flo, I love how you pointed that out, 😎

I also have been really busy lately, and I completely forgot your post, 😉 Sorry about that. You might want to post your solution for others to see how you...

No problem, thanks for your feedback, it is always appreciated to know we can help!

When you execute that procedure, within sql server, or within a .net application, the connection gets opened with a SPID. That id is your connection ID. If you "block" the...

You are probably within a blocking transactions. You must have done an insert in the global temp table, or an update, and the table is still locked to the procedure....

So, you do not want to execute code when yesterday was an holiday, just do a -1 day to the "@Today" Variable, in the code I gave you, and you...

This query does exactly what you are looking for, just add your code (what you want to do) between the begin/end of the if statement.

GSquared (3/23/2009)

---

Per Books Online:

Note that it says, "execution errors". Those are...

What version of SQL Server are you using? I had this problem when I did not have the right service pack. Upgrading the service pack stops "Pre executing" the transactions...