>My data source is db2, an iSeries/AS400 machine. What if I put all my filter criteria in the middle SQL statement. It seems to work a lot faster but I am not sure it will yeild the correct results in every situation. Here is the modified code.
>
>

>sql = "Select recseq, CASE WHEN faistatus = 1" +
>					" THEN 'Accepted' WHEN faistatus = 2 THEN 'Rejected' ELSE 'SEE ORIGINAL FAI' END" +
>					" As fais, inspectord, dwgrev, datstmpi From webprddt6.drawmfai mt1" +	
>					" JOIN ( SELECT webprddt6.drawmfai.partno, MAX(webprddt6.drawmfai.datstmpi) AS MaxDate FROM webprddt6.drawmfai" +
>					" Where partno in('" + p1+ "','" + pnmod + "','" + modpartno + "','" + LEFT(p1,11)+ "','" + Left(p1,10)+ "','" + Left(p1,9) + "','" + Left(p1,8) +
>					"') And toolinspr = 0 And conformir = 0 And DATE(datstmpin) is Not NULL GROUP BY webprddt6.drawmfai.partno) mt3" +
>					" ON mt3.partno = mt1.partno AND mt1.datstmpi = mt3.MaxDate";
>									
>
>

If you don't have duplicate dates for each PartNo, this query will yield the same results as the original.