Welcome to Sign in | Help

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

  •  02-05-2007, 2:46 PM

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

    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
View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems