As a Microsoft partner, SQL would be the best fit, and would have the least code ramifications at this stage. I already have the MERGE part working in a .NET...

Unfortunately, I had tried an OUTPUT in another scenario. SQL won't accept the OUTPUT because the target is a partitioned view:

The OUTPUT clause cannot be specified because the target view...

After playing around with the script, I managed to gain some 'success'. I modified the INSERT part of the script as follows:

INSERT dbo.LogData

( LogID

, Value

, Attribute

, TimeStamp )

SELECT

TARGET.LogID

,...

Bill,

Thanks for the info. Your script is quite close to what I had managed to attain in the meantime. However, I'm falling down on the INSERT part (UPDATE works fine)...