INSERT INTO [AccountToSync]
 SELECT * FROM OPENQUERY([REMOTESERVERNAME],' SELECT  TOP  1000
 [column1],[column2],[column3] FROM RemoteDBName.dbo.Account
 inner join LocalDBName.dbo.CUSTOMER on PRVBRANCH  = CUSBRANCH
 inner join LocalDBName.dbo.ACCOUNT on PRVBRANCH = ACCBRANCH
 where ACCRECNO > 0 And PRVCODE IN (''DUAL005'', ''ADP'', ''ADPGRP'')
 and (AccChanged & 1 <> 0 AND AccChanged & 2 = 0)
 Order By PRVDATEEXPIRES Desc ')