You didn't mention what level of access you have to the database in question. If you're not mapped to the owner of the stored procedure (for example, 'dbo'), then your...

Sorry, I was answering the other question, not your statement. You're correct. That, in fact, is probably what he needs to do. I apologize for any confusion.

I don't think you can. At least, I don't seem to be able to in the tests I've run so far. However, can you, instead, return a larger set of...

Sorry, we don't check to see if records exist, we simply insert them as part of changes otherwise your approach would work very well. What I showed is the select...

I agree on the recursion. I've implemented one solution using it and I was VERY sorry afterwards.

We have a need to only every insert data, no updates. So, we have a...

If I understand the question... No. You can't pass parameters to a view.

Thanks for the correction. 100% accurate. Apologies for the bit of bad info.

Download the AdventureWorks database from Microsoft. It's a pretty good place for running tests & learning.

http://www.microsoft.com/downloads/info.aspx?na=22&p=1&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=&u=%2fdownloads%2fdetails.aspx%3fFamilyID%3de719ecf7-9f46-4312-af89-6ad8702e4e6e%26DisplayLang%3den

There is a lot of time in Itzik's book on graphing & trees & pivots that, in my opinion, won't be used by most people (myself included). However the APPLY &...

I want to jump on the band wagon and recommend Itzik Ben-Gan's "Inside TSQL Querying". Add to it his "Inside TSQL Programming". The first book is all about TSQL queries. The...

Generally, it's probably safer to create the index & temp table together and then add data to it. Clearly it's affecting the locking, but it will also cause recompiles.

SQL Server takes exclusive locks on a row, page or data when it wants to perform a write operation. You've got a process within your stored procedure that is escalating...

It looks like you may be hitting a bug. I found this kb article that seems to describe your situation:

http://support.microsoft.com/kb/935356

"In SQL Server 2005, assertion error 3624 may occur. The...

Good catch. Once I spotted that USING word I couldn't see much else.

Forgive us our typos as we forgive those who typo against us... unless you just ran a restore on the production server...