Yes, you are right. This is why I provided a desired output.

Anyway, I did it differently,...

Now everybody howl and kneel before Peter Larsson!

Peter, this is very close to what I was looking for. Thank you.

I just have to...

Here is the sample data.

In the DesiredOutput you find with bright green background the records where the Exceptions have been aplied. In all other records, the Default ConversionRate has...

David!

The first solution is out of the question It is too static solution. If one of the combinations changes,...

Make the account of the SQL Server service domain admin, and you can do whatever you want. Even execute remote .exe files

I also vote for Steve's solution. But I would change the second statement using a left join:

insert INTO Table1

(Firm, ID)

select table2.firm, table2.test

from table2

LEFT JOIN table1

ON table2.firm = table1.firm

WHERE table1.firm IS...

Could you be more specific? Or could you provide some example?

It seems, that basically you are saying: "I need to order a table, but I cannot use order by on...

What about current process/services rights on the other server?

Typical problems in this cases are, that the NTuser under which the process trying to start the job has no appropriate permission on...

Hi Mike!

You saved me from a lot of trouble!

For a smaller database it took me a half day to get done this job done "manual".

When I got to a bigger...

Ok!

Thank you Antares for your help!

Best regards,

Botond

Ok. Thanx everybody for your help.

But I need some more ideas. The solution I am looking for must be one that is not affecting the code that is already written....

Thank you, hurcane, for your help!

It always helps to see some new solutions!

Best regards,

Botond

You are wright. From the example I just gave, this is the conclusion.

But I simplified my problem in this example.

Believe me, in may case SoredProc2 is necessary, because it is...

A (primitive) solution could be joining 4 time the table with itself, like this:

select

tbl3.col1, tbl3.col2,

tbl3.col3, tbl4.col4, tbl5.col5, tbl6.col6

from

(select * from #tmp where col3 is not null) tbl3

inner join

(select...

Thank you! :))

Your's is faster and much more simple. 🙂

Probably that's why I didn't manage to figure out myself... it was too simple! 🙂

Thanx again for your time!

Best regards,

Botond

Edited by...