As for when to use a cursor, I've used these:

For looping thru dbs, the classic sp_foreachdb (my souped-up version, I don't use the MS version).

For relatively complex processing where you...

I don't like the dual FETCH statements most people use for cursors.  It often causes errors when one cursor gets changed and the other doesn't.  I'd like your feedback on...

I've...

Thanks

(3) Data in memory (in a buffer) that is forcibly written to disk is said to be "flushed".  This does not mean any type of problem/error has occurred. ...

SELECT
    m.A AS original_currency, m.B AS posting_currency, 
    /*...,*/
    m.value AS original_value,
    COALESCE(m.value * cc.conversion_rate...

You will also need the date (at least), since currency conversion values change over time.

Hy Scott,

Thanks for your reply and useful advises, but what kind of filter i must put in the Where condition inside the Begin ?

i think that the field dostamp...

You don't have any WHERE condition in the SELECT in the loop.  Thus, so it's essentially random which row SQL will return.

Btw, don't use functions against table columns in the...

Yes.    Eirikur's version of DelimitedSplit8k is fast AND is an inline table valued function.   Everyone who can't use String_Split should get a copy.   Also, use of an...

Yes, in theory could be less efficient in some cases than a LOOP join.  But it's still reasonable performance.  You'll never totally drop off a performance cliff going from LOOP...

First let's correct the PK.  Then the code for the proc.

ALTER TABLE [dbo].[Contracte] DROP CONSTRAINT [PK_Contracte];
ALTER TABLE [dbo].[Contracte] ADD CONSTRAINT [PK_Contracte] 
    PRIMARY KEY...

If it could ever have more than one, then it needs to be a JOIN, just like you have it.

Yeah, seems like a bug in SQL optimizer.  I'd make sure SQL didn't use a LOOP join (gack!) for the two main tables.  I think the hint will also force...

You're welcome!

The source table, DBSource.dbo.Contacts, must have duplicate entries for the same ContactID.