Go with Michael's solution 🙂

You could use a LOT of if statements to check for any equalities, or perhaps something like (the syntax ought to be correct)

if 5 = (

...

I've had similar distributed transaction problems with Oracle and FoxPro linked servers. The trick is to get the data to a scratch/temporary table outside of your begin/end transaction. ...

It's very possible to do this without dynamic SQL. Do a google search for

array sql server function

In fact, this is the very article you should read - http://www.sommarskog.se/arrays-in-sql-2005.html

Enjoy...

It appears to me that there's no data manipulation code in there at all. When Jeff/Steve said they wanted SQL code, they meant SQL code, not a dump of...

I haven't played much with it but I believe you're correct in assuming that the schema is another layer in the hierarchy / tree of permissions. Database -> schema...

Why are you storing the parent key at all? You already have the phone key in the parent table (vendors, etc) which is your link (along with the pkey...

What if you did your bulk insert into a staging table and then, using normal T-SQL, execute the insert statement selecting from the staging table? You can then issue...

With restores like that I usually cheat and use the GUI tools. They show you the list of backups within the backup file (as you can have >1 in...

I still don't understand what you're trying to accomplish. Can you perhaps give some background to the story? Is it homework or just a boss who says "it...

It's not possible to detach a db from 2005 and attach it to 2000, even if you make zero changes to it and even if the compatibility level is 80....

If you cannot change his code's behaviour (ie the dropping of procs is not a server-side job) then you could (and it's clumsy) create a job to run every...

Depending on how many transactions occur in your database some smart use of indices on the columns used to populate parameter values could also help.

Such things are best done in client side code. It sounds like you might be making your stored procedure too generic.

Before asking the question do an article search on this site. I'd be incredibly surprised if there's not something on here about self joins.

In fact, this article talks about...