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.
| Author |
Topic |
|
korssane
Posting Yak Master
104 Posts |
 Posted - 2009-12-02 : 09:49:31
|
| Hi All ,i am trying to access Oracle data via an Open query syntax.i need to pull some data according to another parameter (Date) i have locally in my sql 2005 table but getting error.the openquery works fine if i specify a date within a query but that is not what i want..i want to joing the oracle data with my local table...and it is been a while i am looking for help but no result..any help will be greatly appreciated ...thanks here the part of my code ..SELECT date1,(SELECT * FROM OPENQUERY(LINKED_SERV, 'SELECT p1.queue,p1.timekeyFROM ORA.INPUT_day p1WHERE (p1.objectid = ''9999'')' )) peFROM Localtable p2 INNER JOIN ORA.INPUT_day pe ON pe.timekey = p2.date1; |
|
|
|
|
|
OPEN QUERY HELP