Hi

I have got the initial piece of code Chris posted to work.

Thanks for the help.

I think I may have confused the matter in my last post which was;

SELECT

S.ID,

(SELECT TOP 1 D.INFO FROM (SELECT TOP 2 * FROM PRODUCTS WHERE PRODUCTS.ID = S.ID AND [DESC]...

Hi Seth

The complete query is as follows (apologies);

SELECT

S.ID,

(SELECT TOP 1 D.INFO FROM (SELECT TOP 2 * FROM PRODUCTS WHERE PRODUCTS.ID = S.ID AND [DESC] LIKE 'FLAG SET TO%' ORDER BY...

Hi (again)

I have modified a piece of code (suggested by Chris) that works on its own but as a subquery I am getting the following error;

Only one expression can be...

Chris, that has worked a treat. Many Thanks.

Thanks Andras

You gave me the inspiration for solving this problem. I have placed the DATEFIRST in DTS that exports the data to Excel and it works.