using a local subquery with a linked server

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

using a local subquery with a linked server

Author

Topic

smccreadie
Aged Yak Warrior

505 Posts

Posted - 2001-09-06 : 15:54:36

I'm trying to pull data from a remote server (Oracle) using a local subquery based on a temp table. Can I do this?

My code is

SELECT DATE_VERIFIED, DATETIME_TEST_PERFORMED, EVENT_CDR_ID,
	FILLER_APP_ORDER_NBR, HI_LOW_AA_FLAG, PATIENT_CDR_ID,
	REFERENCES_RANGE, RESULT_SEQ, RESULT_STATUS, RESULT_TEST_CODE, RESULT_TEST_NAME,
	RESULT_TYPE, RESULT_UNITS, RESULT_VALUE, RESULT_TEXT
FROM OPENQUERY(CDRQ, 'SELECT DATE_VERIFIED, DATETIME_TEST_PERFORMED, EVENT_CDR_ID,
	FILLER_APP_ORDER_NBR, HI_LOW_AA_FLAG, PATIENT_CDR_ID,
	REFERENCES_RANGE, RESULT_SEQ, RESULT_STATUS, RESULT_TEST_CODE, RESULT_TEST_NAME,
	RESULT_TYPE, RESULT_UNITS, RESULT_VALUE, RESULT_TEXT
FROM CDR.CLINICAL_RESULT WHERE PATIENT_CDR_ID IN (SELECT PATIENT_CDR_ID FROM WSPH3031.cdr_test.dbo.#PTLIST)')

All of this gets dumped into a local SQL table (code not shown)

I try to run it and get
Server: Msg 7321, Level 16, State 2, Line 1
An error occurred while preparing a query for execution against OLE DB provider 'MSDAORA'.
[OLE/DB provider returned message: ORA-00907: missing right parenthesis
]

Is there just a syntax issue or should I approach this another way?

Thanks

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources