Thanks for the reply,

I've got things working now - if only there was an option to output column names in BCP...

Okay, so I've modified the script to utilise BCP, but when it executes it doesn't run successfully. Instead, it shows the usage commands for BCP for each results set, for...

I don't mind which way it is done, as long as I can output each result set to a separate file.

Can this be achieved via BCP?

Thanks Lars - you're a champ!

Thanks for the prompt replies,

The reason I ask it to do with daylight savings and GMT. I was looking to apply the following logic, and I believe what you have...

Perfect!

Thanks for the prompt reply.