>>>>>>NOFILTER is a must in your situation because you're selecting all the columns and using a where condition. It may result in the filtered result.
>>>>>
>>>>>Sorry, but you're wrong.
>>>>
>>>>What do you mean? You mean it's not possible the above query will result in the filtered set?
>>>
>>>The query may give a filtered record set, but so what? The "copy to" command will respect the automatically created filter.
>>
>>That I know. But it still better to avoid filtered set.
>
>Depending on what you need the cursor for. In this particular case a filtered record set will work just fine.

Sorry Tore, but I'm going to disagree with you. It may work just fine - the danger is that the developer may want to include a record count in the excel. If it is a filtered set, then using RECCOUNT() will report the unfiltered count of the base table. That little distinction is the kind of thing that causes errors.