Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to filter data based on the table value?

Status
Not open for further replies.

sqlval

Programmer
Jan 12, 2011
10
US
I have a set of data coming from Oracle DB into SQL server. There is a table in SQL Server that stores key dates that should be used to filter data that comes from Oracle. Basically, I want to load only the records that were updated in Oracle after a particular date stored in SQL Server. Is it doable?
Thank you in advance for your ideas.
 


Select "what ever data you require"
from "whatever your oracle tabel is called"
where "date in oracle table" > "select date from sqltable"


I love deadlines. I like the whooshing sound they make as they fly by
Douglas Adams
(1952-2001)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top