Daca merge SELECT-ul simplu (de mai sus), atunci te rog incearca si:

CREATE TABLE #T (N int)
INSERT INTO #T SELECT COUNT(*) FROM OPENQUERY(ORADEV,'select * from VWIREP_BAG_LD')
DROP TABLE #T

Razvan