Using OpenQuery for select Statement Help!!!!

[bmann]

Here is some sample data below. all I am trying to do is pull records from a large recordset by selecting all records in the DOB table with timestamp > timestamp field from the TIMESTAMPTABLE.

select * FROM LAcalphoto.DOJviews.dbo.DOB
where timestamp > (select timestamp from Los_Angeles_CALPHOTO.dbo.TIMESTAMPTABLE)

DOB Table

FCN Timestamp
10 2/4/2011
11 1/5/2011

Timestamptable

Timestamp
2/3/2011

 

[markros]

Try a sight change

select * FROM LAcalphoto.DOJviews.dbo.DOB
where timestamp > (select max(timestamp) from Los_Angeles_CALPHOTO.dbo.TIMESTAMPTABLE)

Also, are you using Linked Servers?

PluralSight Learning Library

 

[bmann]

Yes the linked server is LAcalphoto

select * FROM LAcalphoto.DOJviews.dbo.DOB
where timestamp > (select max(timestamp) from Los_Angeles_CALPHOTO.dbo.TIMESTAMPTABLE)