Hi Lutz,

It seems I didn't make myself clear enough.

This is the case when the exact value used for an update is unpredictable: can be 100 or 200.

In this particalar SP...

Is your customers table involved in Replication?

Could you please tell me what's the advantage of using CTE and ROW_NUMBER() over a mush more intuitive temporary table with an IDENTITY(1,1) field?

Eddi, thank you very much for your comprehensive answer - which begs for a couple more questions:

1. I followed your link to MS Licensing Guide. Is it a) just...