That will work for up to 23:59:59.  If it goes past 24 hours, it will silently fail and give you an incorrect answer.  Do you need something that will...

and sorry regarding

, I was able to figure out how to format the way I wanted...

Thanks for the messages folks.  I managed to get the results I was after with the suggestion from ScottPletcher.

Jeff - the data is coming a Microsoft Excel sheet which is...

A freelancer helped me to get this working. While I don't profess to know for sure that he didn't do more than what I'm about to try (inadequately) to...

Thanks Phil. I had submitted a support ticket a few days ago to Verio's new support team requesting that info but received nothing in response. Can't reach them...

Thanks for the reply Thom. How do you think people generally work with these servers then? If they can't connect through SSMS due to not having the IP...

Okay thanks for the insight Jeff, much appreciated.

Thanks Jeff, I like this idea because I'll be generating the format file using BCP and dynamic SQL. I read here http://social.msdn.microsoft.com/Forums/sqlserver/en-US/5e996cc4-466a-4569-912a-8782beba6806/bcp-and-dynamic-sql?forum=transactsql that there's a 4000 character limit for...

Okay after hammering away for a while I figured this out. Since my header row contains text qualifiers, I had assumed that I needed to include those in my...

After working on this further, I've been able to get things going but hit a roadblock when I encountered text qualifiers in the header of my data. I just...

Okay great, thanks - have to go do something else this evening but I will do tomorrow if I can't figure it out in the morning.