I am afraid it is a limitation of SQL IN clause. I believe you could do it separately:

select DISTINCT TOP 2 date FROM tempAgg WHERE quarter = cPquart ORDER BY date into curs temp nofilt

SELECT * from tempAgg INTO CURSOR cuAgg WHERE date in (select date from temp)

>Hello,
>
>The following sql command generates a "command is missing required clause" error. Can anyone help me??? Thanks!!!
>
>SELECT * from tempAgg INTO CURSOR cuAgg WHERE date in (select DISTINCT TOP 2 date FROM tempAgg WHERE quarter = cPquart ORDER BY date)
>
>
>- tb