best way to tackle this process

[tjsingh]

Hi

I have some code which basically produces a receipt report.

But i want to exclude some orders which end with 'X'. which is easily done as i am currently exlduing orders which end with 'b'.

I was thinking to do the normall processing but when it comes to an order with an X, to populate a temp table. The reason is that i need to out put this into text file but need the normal orders and then after they have been outputted i need to put all the 'X' orders below the list.

Just thinking which is the most effcient way of doing this

cheers

tj

 

[tamhas]

Either a temp-table or a separate query sound like possibilities, depending on your indexing.