From what you've said, I think the temp table / table variable (each should be tried to see which is faster) is the way to go too.

Can you change the back-end field types to nvarchar, rather than doing the converts?  I'm guessing not.

So you actually want to DELETE the data from table A that's already in tableb?

If so

delete from TableA

where tableA.ID in (select ID from tableB)

should do the trick.  Obviously, I'm assuming...

Also, getting rid of the in-line CONVERTs would speed things up.

There's probably a fancy way, but you could always create a new ID field in table Y (identity, seed = 12000 (or whatever you need your numbering to start at),...

Could this be a security issue?  If it runs when you execute it manually, yet not when it is executed by the SQL Server Agent, that is what I would...

Can you overwrite the path with one that is valid before the error message appears?  Sorry, I should know, but I haven't done this for a while.

Are you sure it's a 'him'?

Only kidding ladies

I agree with AJ Ahrens - it should recreate the log file if none exists.

Can you post the full device 'activation error' message?

Regards

But aren't your customers in tblPaxList?  When you create the ServiceRefNo self join on tblPaxList, the returned recordset will be larger than required because ServiceRefNo is not unique on tblPaxList...

Sorry to mess you about, but this is tough to crack without also seeing the base data.  As you've already identified, you're getting too many results as a consequence of...

What error message do you get?

I am sure that this can be achieved without the need for the query you originally requested.

Can you post sample details showing the query you are running, the output you...

This sounds like an unusual way to do things.  Can you go into more detail about what you will be using the resultset for and perhaps we will find another, more...

So

select product, city

from product_cities

where city = 'boston' or city = 'chicago' or city = 'denver'

is not what you want?  (I know you're using IDs, but the theory's the same)...