Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
majnoon
Starting Member
26 Posts |
 Posted - 2003-08-26 : 05:59:09
|
| Hi:I am having a problem getting the following query to work. WT47SQL1.COMPASSInformation_ORACLE.dbo.F4211 is a linked Server, both servers are SQL Server 2000SELECT F4211_ORACLE.* FROM WT47SQL1.COMPASSInformation_ORACLE.dbo.F4211 F4211_1 RIGHT OUTER JOIN F4211_ORACLE ON F4211_1.ROWID_BIGINT = F4211_ORACLE.ROWID_BIGINTWHERE F4211_1.SDACOM <> F4211_ORACLE.SDACOM OR F4211_1.SDADDJ <> F4211_ORACLE.SDADDJ OR F4211_1.SDAEXP <> F4211_ORACLE.SDAEXP OR F4211_1.SDAFT <> F4211_ORACLE.SDAFT OR F4211_1.SDAID <> F4211_ORACLE.SDAID OR F4211_1.SDAITM <> F4211_ORACLE.SDAITM OR F4211_1.SDAN8 <> F4211_ORACLE.SDAN8 OR F4211_1.SDANBY <> F4211_ORACLE.SDANBY OR F4211_1.SDANI <> F4211_ORACLE.SDANI OR F4211_1.SDAOPN <> F4211_ORACLE.SDAOPN OR F4211_1.SDAPTS <> F4211_ORACLE.SDAPTS OR F4211_1.SDAPUM <> F4211_ORACLE.SDAPUM OR F4211_1.SDASN <> F4211_ORACLE.SDASN OR F4211_1.SDATXT <> F4211_ORACLE.SDATXT OR F4211_1.SDBACK <> F4211_ORACLE.SDBACK OR F4211_1.SDBALU <> F4211_ORACLE.SDBALU OR F4211_1.SDCADC <> F4211_ORACLE.SDCADC OR F4211_1.SDCARS <> F4211_ORACLE.SDCARS OR F4211_1.SDCDCD <> F4211_ORACLE.SDCDCD OR F4211_1.SDCLVL <> F4211_ORACLE.SDCLVL OR F4211_1.SDCMCG <> F4211_ORACLE.SDCMCG OR F4211_1.SDCMGL <> F4211_ORACLE.SDCMGL OR F4211_1.SDCMGP <> F4211_ORACLE.SDCMGP OR F4211_1.SDCNDJ <> F4211_ORACLE.SDCNDJ OR F4211_1.SDCNID <> F4211_ORACLE.SDCNID OR F4211_1.SDCO <> F4211_ORACLE.SDCO OR F4211_1.SDCOMM <> F4211_ORACLE.SDCOMM OR F4211_1.SDCOT <> F4211_ORACLE.SDCOT OR F4211_1.SDCPNT <> F4211_ORACLE.SDCPNT OR F4211_1.SDCRCD <> F4211_ORACLE.SDCRCD OR F4211_1.SDCRMD <> F4211_ORACLE.SDCRMD OR F4211_1.SDCRR <> F4211_ORACLE.SDCRR OR F4211_1.SDCSTO <> F4211_ORACLE.SDCSTO OR F4211_1.SDCTRY <> F4211_ORACLE.SDCTRY OR F4211_1.SDDCT <> F4211_ORACLE.SDDCT OR F4211_1.SDDCTO <> F4211_ORACLE.SDDCTO OR F4211_1.SDDELN <> F4211_ORACLE.SDDELN OR F4211_1.SDDFTN <> F4211_ORACLE.SDDFTN OR F4211_1.SDDGL <> F4211_ORACLE.SDDGL OR F4211_1.SDDMCS <> F4211_ORACLE.SDDMCS OR F4211_1.SDDMCT <> F4211_ORACLE.SDDMCT OR F4211_1.SDDOC <> F4211_ORACLE.SDDOC OR F4211_1.SDDOCO <> F4211_ORACLE.SDDOCO OR F4211_1.SDDRQJ <> F4211_ORACLE.SDDRQJ OR F4211_1.SDDSC1 <> F4211_ORACLE.SDDSC1 OR F4211_1.SDDSC2 <> F4211_ORACLE.SDDSC2 OR F4211_1.SDDSFT <> F4211_ORACLE.SDDSFT OR F4211_1.SDDSPR <> F4211_ORACLE.SDDSPR OR F4211_1.SDDTBS <> F4211_ORACLE.SDDTBS OR F4211_1.SDDTYS <> F4211_ORACLE.SDDTYS OR F4211_1.SDECST <> F4211_ORACLE.SDECST OR F4211_1.SDEMCU <> F4211_ORACLE.SDEMCU OR F4211_1.SDEUSE <> F4211_ORACLE.SDEUSE OR F4211_1.SDEXDP <> F4211_ORACLE.SDEXDP OR F4211_1.SDEXR1 <> F4211_ORACLE.SDEXR1 OR F4211_1.SDFAPP <> F4211_ORACLE.SDFAPP OR F4211_1.SDFEA <> F4211_ORACLE.SDFEA OR F4211_1.SDFEC <> F4211_ORACLE.SDFEC OR F4211_1.SDFPRC <> F4211_ORACLE.SDFPRC OR F4211_1.SDFRAT <> F4211_ORACLE.SDFRAT OR F4211_1.SDFRGD <> F4211_ORACLE.SDFRGD OR F4211_1.SDFRMP <> F4211_ORACLE.SDFRMP OR F4211_1.SDFRTC <> F4211_ORACLE.SDFRTC OR F4211_1.SDFRTH <> F4211_ORACLE.SDFRTH OR F4211_1.SDFUC <> F4211_ORACLE.SDFUC OR F4211_1.SDFUF1 <> F4211_ORACLE.SDFUF1 OR F4211_1.SDFUN2 <> F4211_ORACLE.SDFUN2 OR F4211_1.SDFUP <> F4211_ORACLE.SDFUP OR F4211_1.SDFY <> F4211_ORACLE.SDFY OR F4211_1.SDGLC <> F4211_ORACLE.SDGLC OR F4211_1.SDGRWT <> F4211_ORACLE.SDGRWT OR F4211_1.SDGWUM <> F4211_ORACLE.SDGWUM OR F4211_1.SDINMG <> F4211_ORACLE.SDINMG OR F4211_1.SDITM <> F4211_ORACLE.SDITM OR F4211_1.SDITVL <> F4211_ORACLE.SDITVL OR F4211_1.SDITWT <> F4211_ORACLE.SDITWT OR F4211_1.SDIVD <> F4211_ORACLE.SDIVD OR F4211_1.SDJOBN <> F4211_ORACLE.SDJOBN OR F4211_1.SDKCO <> F4211_ORACLE.SDKCO OR F4211_1.SDKCOO <> F4211_ORACLE.SDKCOO OR F4211_1.SDKTLN <> F4211_ORACLE.SDKTLN OR F4211_1.SDKTP <> F4211_ORACLE.SDKTP OR F4211_1.SDLCOD <> F4211_ORACLE.SDLCOD OR F4211_1.SDLITM <> F4211_ORACLE.SDLITM OR F4211_1.SDLNID <> F4211_ORACLE.SDLNID OR F4211_1.SDLNTY <> F4211_ORACLE.SDLNTY OR F4211_1.SDLOB <> F4211_ORACLE.SDLOB OR F4211_1.SDLOCN <> F4211_ORACLE.SDLOCN OR F4211_1.SDLOTN <> F4211_ORACLE.SDLOTN OR F4211_1.SDLPRC <> F4211_ORACLE.SDLPRC OR F4211_1.SDLT <> F4211_ORACLE.SDLT OR F4211_1.SDLTTR <> F4211_ORACLE.SDLTTR OR F4211_1.SDMCU <> F4211_ORACLE.SDMCU OR F4211_1.SDMOT <> F4211_ORACLE.SDMOT OR F4211_1.SDNTR <> F4211_ORACLE.SDNTR OR F4211_1.SDNXTR <> F4211_ORACLE.SDNXTR OR F4211_1.SDOBJ <> F4211_ORACLE.SDOBJ OR F4211_1.SDOCTO <> F4211_ORACLE.SDOCTO OR F4211_1.SDODCT <> F4211_ORACLE.SDODCT OR F4211_1.SDODOC <> F4211_ORACLE.SDODOC OR F4211_1.SDOGNO <> F4211_ORACLE.SDOGNO OR F4211_1.SDOKC <> F4211_ORACLE.SDOKC OR F4211_1.SDOKCO <> F4211_ORACLE.SDOKCO OR F4211_1.SDOMCU <> F4211_ORACLE.SDOMCU OR F4211_1.SDOORN <> F4211_ORACLE.SDOORN OR F4211_1.SDOPDJ <> F4211_ORACLE.SDOPDJ OR F4211_1.SDORP <> F4211_ORACLE.SDORP OR F4211_1.SDORPR <> F4211_ORACLE.SDORPR OR F4211_1.SDOTQY <> F4211_ORACLE.SDOTQY OR F4211_1.SDPA8 <> F4211_ORACLE.SDPA8 OR F4211_1.SDPDDJ <> F4211_ORACLE.SDPDDJ OR F4211_1.SDPEFJ <> F4211_ORACLE.SDPEFJ OR F4211_1.SDPID <> F4211_ORACLE.SDPID OR F4211_1.SDPPDJ <> F4211_ORACLE.SDPPDJ OR F4211_1.SDPQOR <> F4211_ORACLE.SDPQOR OR F4211_1.SDPRGR <> F4211_ORACLE.SDPRGR OR F4211_1.SDPRIO <> F4211_ORACLE.SDPRIO OR F4211_1.SDPRMO <> F4211_ORACLE.SDPRMO OR F4211_1.SDPROV <> F4211_ORACLE.SDPROV OR F4211_1.SDPRP1 <> F4211_ORACLE.SDPRP1 OR F4211_1.SDPRP2 <> F4211_ORACLE.SDPRP2 OR F4211_1.SDPRP3 <> F4211_ORACLE.SDPRP3 OR F4211_1.SDPRP4 <> F4211_ORACLE.SDPRP4 OR F4211_1.SDPRP5 <> F4211_ORACLE.SDPRP5 OR F4211_1.SDPSDJ <> F4211_ORACLE.SDPSDJ OR F4211_1.SDPSN <> F4211_ORACLE.SDPSN OR F4211_1.SDPTC <> F4211_ORACLE.SDPTC OR F4211_1.SDQRLV <> F4211_ORACLE.SDQRLV OR F4211_1.SDQTYT <> F4211_ORACLE.SDQTYT OR F4211_1.SDRATT <> F4211_ORACLE.SDRATT OR F4211_1.SDRCD <> F4211_ORACLE.SDRCD OR F4211_1.SDRCTO <> F4211_ORACLE.SDRCTO OR F4211_1.SDRESL <> F4211_ORACLE.SDRESL OR F4211_1.SDRKCO <> F4211_ORACLE.SDRKCO OR F4211_1.SDRKIT <> F4211_ORACLE.SDRKIT OR F4211_1.SDRLIT <> F4211_ORACLE.SDRLIT OR F4211_1.SDRLLN <> F4211_ORACLE.SDRLLN OR F4211_1.SDRORN <> F4211_ORACLE.SDRORN OR F4211_1.SDROUT <> F4211_ORACLE.SDROUT OR F4211_1.SDRPRC <> F4211_ORACLE.SDRPRC OR F4211_1.SDRSDJ <> F4211_ORACLE.SDRSDJ OR F4211_1.SDRYIN <> F4211_ORACLE.SDRYIN OR F4211_1.SDSBAL <> F4211_ORACLE.SDSBAL OR F4211_1.SDSBL <> F4211_ORACLE.SDSBL OR F4211_1.SDSBLT <> F4211_ORACLE.SDSBLT OR F4211_1.SDSERN <> F4211_ORACLE.SDSERN OR F4211_1.SDSFXO <> F4211_ORACLE.SDSFXO OR F4211_1.SDSHAN <> F4211_ORACLE.SDSHAN OR F4211_1.SDSHCM <> F4211_ORACLE.SDSHCM OR F4211_1.SDSHCN <> F4211_ORACLE.SDSHCN OR F4211_1.SDSLC2 <> F4211_ORACLE.SDSLC2 OR F4211_1.SDSLCM <> F4211_ORACLE.SDSLCM OR F4211_1.SDSLM2 <> F4211_ORACLE.SDSLM2 OR F4211_1.SDSLSM <> F4211_ORACLE.SDSLSM OR F4211_1.SDSO01 <> F4211_ORACLE.SDSO01 OR F4211_1.SDSO02 <> F4211_ORACLE.SDSO02 OR F4211_1.SDSO03 <> F4211_ORACLE.SDSO03 OR F4211_1.SDSO04 <> F4211_ORACLE.SDSO04 OR F4211_1.SDSO05 <> F4211_ORACLE.SDSO05 OR F4211_1.SDSO06 <> F4211_ORACLE.SDSO06 OR F4211_1.SDSO07 <> F4211_ORACLE.SDSO07 OR F4211_1.SDSO08 <> F4211_ORACLE.SDSO08 OR F4211_1.SDSO09 <> F4211_ORACLE.SDSO09 OR F4211_1.SDSO10 <> F4211_ORACLE.SDSO10 OR F4211_1.SDSO11 <> F4211_ORACLE.SDSO11 OR F4211_1.SDSO12 <> F4211_ORACLE.SDSO12 OR F4211_1.SDSO13 <> F4211_ORACLE.SDSO13 OR F4211_1.SDSO14 <> F4211_ORACLE.SDSO14 OR F4211_1.SDSO15 <> F4211_ORACLE.SDSO15 OR F4211_1.SDSOBK <> F4211_ORACLE.SDSOBK OR F4211_1.SDSOCN <> F4211_ORACLE.SDSOCN OR F4211_1.SDSONE <> F4211_ORACLE.SDSONE OR F4211_1.SDSOQS <> F4211_ORACLE.SDSOQS OR F4211_1.SDSQOR <> F4211_ORACLE.SDSQOR OR F4211_1.SDSRP1 <> F4211_ORACLE.SDSRP1 OR F4211_1.SDSRP2 <> F4211_ORACLE.SDSRP2 OR F4211_1.SDSRP3 <> F4211_ORACLE.SDSRP3 OR F4211_1.SDSRP4 <> F4211_ORACLE.SDSRP4 OR F4211_1.SDSRP5 <> F4211_ORACLE.SDSRP5 OR F4211_1.SDSTOP <> F4211_ORACLE.SDSTOP OR F4211_1.SDSTTS <> F4211_ORACLE.SDSTTS OR F4211_1.SDSUB <> F4211_ORACLE.SDSUB OR F4211_1.SDSWMS <> F4211_ORACLE.SDSWMS OR F4211_1.SDTAX1 <> F4211_ORACLE.SDTAX1 OR F4211_1.SDTCST <> F4211_ORACLE.SDTCST OR F4211_1.SDTDAY <> F4211_ORACLE.SDTDAY OR F4211_1.SDTHGD <> F4211_ORACLE.SDTHGD OR F4211_1.SDTHRP <> F4211_ORACLE.SDTHRP OR F4211_1.SDTORG <> F4211_ORACLE.SDTORG OR F4211_1.SDTPC <> F4211_ORACLE.SDTPC OR F4211_1.SDTRDC <> F4211_ORACLE.SDTRDC OR F4211_1.SDTRDJ <> F4211_ORACLE.SDTRDJ OR F4211_1.SDTXA1 <> F4211_ORACLE.SDTXA1 OR F4211_1.SDUNCD <> F4211_ORACLE.SDUNCD OR F4211_1.SDUNCS <> F4211_ORACLE.SDUNCS OR F4211_1.SDUOM <> F4211_ORACLE.SDUOM OR F4211_1.SDUOM1 <> F4211_ORACLE.SDUOM1 OR F4211_1.SDUOM2 <> F4211_ORACLE.SDUOM2 OR F4211_1.SDUOM4 <> F4211_ORACLE.SDUOM4 OR F4211_1.SDUOPN <> F4211_ORACLE.SDUOPN OR F4211_1.SDUORG <> F4211_ORACLE.SDUORG OR F4211_1.SDUPC1 <> F4211_ORACLE.SDUPC1 OR F4211_1.SDUPC2 <> F4211_ORACLE.SDUPC2 OR F4211_1.SDUPC3 <> F4211_ORACLE.SDUPC3 OR F4211_1.SDUPMJ <> F4211_ORACLE.SDUPMJ OR F4211_1.SDUPRC <> F4211_ORACLE.SDUPRC OR F4211_1.SDURAB <> F4211_ORACLE.SDURAB OR F4211_1.SDURAT <> F4211_ORACLE.SDURAT OR F4211_1.SDURCD <> F4211_ORACLE.SDURCD OR F4211_1.SDURDT <> F4211_ORACLE.SDURDT OR F4211_1.SDURRF <> F4211_ORACLE.SDURRF OR F4211_1.SDUSER <> F4211_ORACLE.SDUSER OR F4211_1.SDVEND <> F4211_ORACLE.SDVEND OR F4211_1.SDVLUM <> F4211_ORACLE.SDVLUM OR F4211_1.SDVR01 <> F4211_ORACLE.SDVR01 OR F4211_1.SDVR02 <> F4211_ORACLE.SDVR02 OR F4211_1.SDWTUM <> F4211_ORACLE.SDWTUM OR F4211_1.SDZON <> F4211_ORACLE.SDZON I keep getting an error saying that SQL Server cannot resolve a Collation ConflictHas anyone come across a similar error, and if so how was it resolved. Thanks in advance of your helpWishing you a peaceful journey |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2003-08-26 : 06:03:32
|
| You may find that this query runs faster with = and AND, though ICBW.Anyway, your message is because one (or more) of your text columns has different collation. Check the DDL from the scripted tables to see if the collation is the same on both servers for the columns being compared, then for where it is not specify the collation for that column such asF4211_1.SDZON COLLATE Latin1_General_CI_AS <> F4211_ORACLE.SDZON COLLATE Latin1_General_CI_AS-------Moo. :) |
 |
|
|
majnoon
Starting Member
26 Posts |
Posted - 2003-08-26 : 07:57:13
|
| Thanks for thatWishing you a peaceful journey |
|
|
|
|
|
|
Collation Conflict