>Hello,
>I want to perform a COPY TO command to create a delimited file of a SQL Server table. There is a date type field in the table, but in the delimited file I need it to be YYYYMMDD format. Anybody know how I can do that with the COPY TO command? I am hoping to avoid having to write a custom procedure to do this.
select field1, field2, ... dtos(yourdatefield) as field42, field43...;
from yourtable into TheCursor
copy to ...