13Oct2006 knystrom

** EDW_Finder_File resides on local sql server
** DS_EDW is the name of the Oracle server linked on my local MS SQL Server
** sample sql also shows how to overcome the different date ranges acceptable on Oracle versus MS SQL Server



SELECT    distinct EDW.*
FROM         EDW_Finder_File INNER 
JOIN
                      OPENQUERY(DS_EDW, 
            
          'Select DISTINCT
EDW_PERS_ID, 
NETID_PRINCIPAL,
NETID_DOMAIN,
ENTRP_ID_IND,
DECODE(NETID_EFF_DT, GREATEST(NETID_EFF_DT, 
TO_DATE(''01/01/1753'',''MM-DD-YYYY'')), NETID_EFF_DT, NULL) 
as NETID_EFF_DT, 
NETID_POST_DT
FROM         EDW.T_NETID')
                       EDW ON EDW_Finder_File.EDW_PERS_ID = 
EDW.EDW_PERS_ID