Then this answer doesn't need to be typed .

I think you'll have to come up with both versions of the code and see which runs faster.

My guess would be that 3 derived tables joined with the facility id...

Case cannot return 2 different values. You must use this technic :

Order by

Case when @sort = 'Col1' Then Col1 ELSE NULL end

, Case when @sort = 'Col2' Then...

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.