AM de facut interogarea asta asupra unor tabele dintr-un linked server dbf si obtin mesajul asta de eroare

OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "concurenta" returned message "Query is too complex.".

Interogarea este asta:

select sector,sum(cifra_af) as cifra_af,sum(cifra_af) as sumagrupa,'' as pp,'' as codi,sum(cifra_af)/(select sum(cifra_af) from concurenta...concur) as procjud,sum(act_circ+act_imob) as totalact,sum(nr_sal) as nr_sal,'' as deni,'' as adresa

from concurenta...concur a ,concurenta...nomcaen2 b WHERE a.caen not in (4100,6323,122,2942,701,111,6024,1581,2010,6023,9303,1822,1561,2030,2670,45,42,2523,4521,7031,6321,3110,1740,1551,2430,4030,121,4523,2913,1821,1120,1722,2956,3614,2911,1596,1421,2875,113,125,1511,2051,9002,3612,2633,1513,6010,2613,3430,2932,2451,3710,1712,2125,1593,3530,2414,4022,1010,1584,3611,1520,1598,4013,2512,2040,112,124,1715,1512,2665,1721,1874,1411,1541,4011,2442,3130,2822,5123,26151531,501,3661,3230,2416,2415,3615,9001,2662,2123,1716,2951,2914,4021,2712,4021,2971,3001,2233,1823,1771,1751) and b.codcaen=a.caen group by sector,a.caen

Are cineva vreo idee?

Multumesc

---

Secolul XXI ori va fi religios ori nu va fi deloc

Asta pare o eroare de Jet...este posibil sa il "supere" lista foarte lunga din "not in"

Incearca sa inlocuiesti "not in" cu un "join"  cu o  "variabila tabel" / tabel temp / tabel  in care ai codurile CAEN care te intereseaza...

merci am rezolvat asa:

select caen,sector,cifra_af,sumagrupa,CIFRA_af/sumagrupa as procgrupa,a.pp,codi,cifra_af/(select sum(cifra_af) from CONCURENTA...CONCUR) as procjud,(act_circ+act_imob) as totalact ,nr_sal,deni ,(stradaf+' nrf:'+nrf+' blf='+BLF+' APF='+apf+' SCF='+SCF) as adresa into #temp2 from CONCURENTA...CONCUR as a,#TEMP1 , CONCURENTA...NOMCAEN2 B WHERE A.PP=#TEMP1.PP and a.caen=B.CODCAEN and a.caen in (4100,6323,122,2942,701,111,6024,1581,2010,6023,9303,1822,1561,2030,2670,45,42,2523,4521,7031,6321,3110,1740,1551,2430,4030,121,4523,2913,1821,1120,1722,2956,3614,2911,1596,1421,2875,113,125,1511,2051,9002,3612,2633,1513,6010,2613,3430,2932,2451,3710,1712,2125,1593,3530,2414,4022,1010,1584,3611,1520,1598,4013,2512,2040,112,124,1715,1512,2665,1721,1874,1411,1541,4011,2442,3130,2822,5123,26151531,501,3661,3230,2416,2415,3615,9001,2662,2123,1716,2951,2914,4021,2712,4021,2971,3001,2233,1823,1771,1751)

select a.caen,sector,sum(cifra_af) as cifra_af, sumagrupa,sum(cifra_af)/sumagrupa as procgrupa,a.pp ,'' as codi,sum(cifra_af)/(select sum(cifra_af) from concurenta...concur) as procjud,sum(act_circ+act_imob) as totalact,sum(nr_sal) as nr_sal,den_caen as deni,'' as adresa

into #temp3 from concurenta...concur a ,concurenta...nomcaen2 b,concurenta...bilcaen c,#temp1 WHERE a.caen not in (select caen from #temp2) and a.caen=b.codcaen and a.caen=c.caen and #temp1.pp=a.pp group by #temp1.sumagrupa,a.pp,sector,a.caen,den_caen

Faza e ca la in nu da eroarea jet provideru ci numai la not in

---

Secolul XXI ori va fi religios ori nu va fi deloc

...pentru putin...

Query-ul tau poate fi adus la o forma mai "omenoasa" folosind sintaxa "ANSI-92"- poti inlocui "IN" / "NOT IN" cu "JOIN"-uri.

Ce-i drept, nu stiu daca dbf accepta asta...dar poti incerca...

Ai putea incerca de asemenea sa importi datele in SQL...