One last question for Pablo or the oracle forum regarding dates in this SQL

SELECT LOG_ID, LOG_NAME, SURGERY_DATE

FROM OPENQUERY(CLARITY, 'SELECT * FROM OR_LOG WHERE SURGERY_DATE = TO_DATE(''08/01/2012'', ''mm/dd/yyyy'')') AS a

What is...

Many thanks Mr. Berzuko:

Your expression works quite well!

My complete pass thru query looks like this:

SELECT LOG_ID, LOG_NAME, SURGERY_DATE

FROM ...

Right you are ColdCoffee

I should have asked sooner

thank you!

Thanks John,

I'll give it a try

jhh

Thank you SSC forums & Lynn

You are indeed a SQL Jeddi Master Lynn

The TVF function with cross apply works like lightning

I have never seen cross apply used before

I've learned...

Thanks Lynn

I'll give it a try

Tell me

Why do you return a table?

I just want to evaluate (Y/N) does the record have any matches within the past 3 years?

jhh

i simply update the sixth field in the table to 1 (no matching records in the past 3 years because exists predicate returns nothing) or 1 (yes there are matching...

Thanks for the reply

It's a scalar function

Returns an integer 1 or 0

jhh

save it to the file system and run it from there

OR

Use a third party app to run the job

Jeffrey Williams,

You rock!

instcat.sql was the solution

Thanks so very much again!

Phunhog

Andrew & Jeff

Sincere thanks for your suggestions.

I've never done a trace (but I know what it is), and I'm not aware of the catalog update you suggest Jeff.

Let me do...

Thanks Marcus,

perhaps I was not clear, My linked server is a default instance. There is no named instance of the linked server.

Got another suggestion?

jhh

paul,

read further up the thread

SQL 2005 does not have the capability to use the MS Access jet database engine as a linked server.

You'll have to take some other approach

I don't...

I'm pretty sure the root cause is allowing one of my users to do some editing in the back end

I'm going to let it go at that.

jhh

Yes

And I've done a restore. All is well thanks.

jhh