Works like a champ!
Thanks
>Try (not tested)
SELECT plan, begindate
> FROM mytable
> WHERE begindate IN (
> SELECT TOP 2 begindate
> FROM mytable
> ORDER BY begindate DESC)
>UNION ALL
> SELECT MAX(plan) + 1, CAST(Null AS D)
> FROM mytable
>ORDER BY begindate DESC
>
>
>>Oops, sorry. I know the problem of not being able to use the order by in the first select. Any ideas on how to return the correct results?
>>
>>John
>>
>>>You've to add 'order by begin_date desc' to the first select in whcih case it cannot be UNION.
>>>