Louis Verbraak
[WD12] Query optimizer June 16, 2009 11:47AM |
Quote
SELECT * FROM HF_ADM_Transacties
WHERE HF_ADM_Transacties.Boekjaar = {iBoekjaar}
AND HF_ADM_Transacties.Dagboek = {sDagboek}
AND HF_ADM_Transacties.Code = {sNummer}
AND HF_ADM_Transacties.Regel > 0
AND HF_ADM_Transacties.RegelCode = 1
AND HF_ADM_Transacties.AfboekRegel = 0
AND HF_ADM_Transacties.Periode >= 0
ORDER BY Regel ASC
Fabrice Harari
Re: [WD12] Query optimizer June 16, 2009 01:37PM |
Louis Verbraak
Re: [WD12] Query optimizer June 16, 2009 01:59PM |
Fabrice Harari
Re: [WD12] Query optimizer June 16, 2009 02:59PM |
Louis Verbraak
Re: [WD12] Query optimizer June 16, 2009 03:36PM |
Piet van Zanten
Re: [WD12] Query optimizer June 16, 2009 05:07PM |
Louis Verbraak
Re: [WD12] Query optimizer June 16, 2009 05:15PM |
Arie
Re: [WD12] Query optimizer June 16, 2009 05:31PM |
Louis Verbraak
Re: [WD12] Query optimizer June 16, 2009 07:12PM |