> Hallo, > > was ist schneller bzw. belastet die DB weniger stark?
Habs mir noch nicht genau angeschaut... H�ngt auch von den Indices ab, die gesetzt sind... Ist das SQL Server? Dann check das doch mal im QueryAnalyzer... Claudius > SELECT > lngINVInvoiceId, > intINVInvoiceNumber, > fltINVINvoiceAmount * > (1 +((SELECT fltVATVATPercent FROM tblVATCodes WHERE lngVATVATCodeID = > tblInvoices.lngVATVATCodeID)/100)) > AS fltINVLongPrice, > (SELECT > nvcCOMCommNumber > FROM > tblCommissions > WHERE > tblInvoices.lngCOMCommID = tblCommissions.lngCOMCommID) AS > lngCOMCommID > FROM > tblInvoices > WHERE bitINVPayedCpltly = 0 > > oder > > SELECT > lngINVInvoiceId, > intINVInvoiceNumber, > fltINVINvoiceAmount * > (1 +((SELECT fltVATVATPercent FROM tblVATCodes WHERE lngVATVATCodeID = > tblInvoices.lngVATVATCodeID)/100)) > AS fltINVLongPrice, > nvcCOMCommNumber > FROM tblInvoices INNER JOIN tblCommissions ON > (tblInvoices.lngCOMCommID = tblCommissions.lngCOMCommID) > WHERE bitINVPayedCpltly = 0 > > > Gruss > > Alex > www.aspintranet.de > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~sponsored by United Planet~~~~~~~~~~~~~~~~~ > Intrexx.BizWalker + ODBC/OLEDB-Daten = ASP-Formular > ATTACK! Download Intrexx CRM-Studio Now! http://www.intrexx.com > _______________________________________________ > Database.asp mailing list > [EMAIL PROTECTED] > http://www.glengamoi.com/mailman/listinfo/database.asp > ~~~~~~~~~~~~~~~~~~~~~~~~~~~sponsored by United Planet~~~~~~~~~~~~~~~~~ Intrexx.BizWalker + ODBC/OLEDB-Daten = ASP-Formular ATTACK! Download Intrexx CRM-Studio Now! http://www.intrexx.com _______________________________________________ Database.asp mailing list [EMAIL PROTECTED] http://www.glengamoi.com/mailman/listinfo/database.asp
