Total agreement. There's a constraint you're not seeing or there's a trigger you're not seeing or, probably, both.

Keep an eye on it. We once had a query, so badly written, that recompiles took over two minutes. We'd get time outs about once every 17 or 18 minutes...

Sure sounds like the trigger may be affecting the data. Can you, without violating business integrity, post the table definition and trigger? Also, you mentioned the incrementing id value? Is...

I have seen differences in how the query optimizer behaves in 2005. Overall, I think it's much better, but it acts choosy. Is it possibly going into recompile? Or is there...

I'm a bit confused. There are three things at work here. First off, creating a procedure

CREATE PROCEDURE x

AS

--followed by creating a table within the proc

--drop it first

IF EXISTS (SELECT *...

Take a look at today's article on CTE's. It shows several methods that might help with this question:

http://www.sqlservercentral.com/columnists/phe/2926.asp

Depending on how complicated you want to get with the query, you...

Look up the statement ALTER TABLE and then follow Lynn Pettis' advice above.

I'd sure like to see the queries before I can completely agree with the conclusions.

I've never been asked anything too odd. However, back in the good ole days of the DOT COM boom, I was interviewed in a backyard sitting on a swing set....

Just to reassure you, you found "the" solution. You didn't have sufficient permissions under your regular login. You had to either get your login the permssions needed, or use a...

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...