Maybe but since it won't be in our accepted target answers you'll have to rethrow it untill you get it right.

Not exists would be faster than not in for this task.

Double posting no, it's like spam and we don't need that.

Right forum, I guess you can point out the fact once, and then they have to do it themselves

Lucky b@$t@rd. My vacations are in one month.

Let's decide this one with a quarter.

Heads I win, tails I don't lose.

Certainly not the slowest .

Sure, but if we don't see that post, how are we supposed to tell them that??

I meant : Can't you simply copy the query from the vb package and use it on the server?

That's why I was asking for clarifications .

Are you back from vacations? Looks like you've been away forever.

(from db1)

Insert into [db1.]dbo.TableName (col1, col2)

Select Col1, Col2 from db2.dbo.TableName2

Simple solution :

Copy the images on a shared drive on the server.

Save the path each the said pictures in the database. Send the path along with the rest...

Can't find anything on global variables that would ressemble @@isolation.

Still happens that someone posts in the wrong forum. They deserve an answer too .

is the #temp table allowed as a parameter?

Can you elaborate on this one AJ?

3. Examine the joins, where statements, etc.. Something as simple as FieldX 'D' can dramatically cause your system to tank (especially...