Very nice David.

I made some changes to the initial load:

INSERT INTO VersionStore

/* Initial Insert to load the VersionStore */

SELECT ItemId

,[Name]

...

I'm not sure but perpahs the problem it's that in sp_ControlStock I'm using temporal tables or OPENQUERY statments because if I use a "simple" store procedure, now it works...

Hi,

SELECT *

FROM OPENROWSET('SQLNCLI', 'Server=.;Trusted_Connection=yes;',

'exec .dbo.sp_who');

It works

But:

SELECT *

FROM OPENROWSET('SQLNCLI', 'Server=.;Trusted_Connection=yes;',

'exec .dbo.sp_ControlStock');

Gets:

Msg 7357, Level 16, State 2, Line 1

Cannot process the object...

Yes I can exec sp_ControlStock without problems...

I make some tests:

exec SGANPS.dbo.sp_ControlStock

It works

SELECT *

FROM OPENROWSET('SQLNCLI', 'Server=.;Trusted_Connection=yes;',

'SELECT *

FROM SGANPS.dbo.ARTICULOS');

It works

SELECT *

FROM...

Hi to all,

I'm trying to use the code, because it's that I need, but I get the error:

Msg 7357, Level 16, State 2, Procedure sp_ConvProc2View, Line 27

Cannot process the object...

Thank you very much.

It works fine.

Ramon

Thank you very much Mike.

It works fine.

You have a friend in Spain forever....

Ramon.

No, the field1 it's the customer's code.

Exactly I want the records of customer 1 in blue, the next customer in black, the next in blue, the next in black, and...