Dude... spend the money.  The information in 837s is really important to people.  You really can't afford to get it wrong because, if you do, you and the company you...

"837" files are an EDI specification.  They can follow either an EDI format or a similar format in XML (but usually not the later).  I wish the world would simply...

Just my humble opinion but, except for the fact that the newer datatypes can use fewer bytes, they pretty much suck for me because you cannot do direct data math...

It does, indeed.  Even if you're only extracting the "BS" record types, it might make sense to split out the first two characters as the record type during import using...

Heh... "must look eye".

A "?" is illegal syntax as a value in T-SQL.  You need to replace that with a variable or a valid constant for the email address.  As...

Thanks, Andrew.  Sounds like you've got is sussed.  What did you do to decrease the I/O problems that you were having?

Andrew, can you confirm that it is the railway schedule CIF file(s) you're working with?

You talk of hoping that people that feel sick won't go out but that's the problem with this virus... you can feel great and actually be spreading the bug in...

I'm seeing dupes in the first 10 lines and an open single quote on the 6th line for starters.

My suggestion would be to make things work in SSMS first and...

I'm curious... are you trying to find this file so you can import it into SQL Server?

Last but not least, is the extra space "unallocated" or "unused"?  If it's "unallocated", it could be from a recent index rebuild.  If it's "unused", you might want to lookup...

Thanks, Matt.  I appreciate the info.  I took a look a while back at SPARK SQL... the syntax of even simple things like DATEADD is quite different but I was...

The XML approach is one of the slowest mostly because of "ExpAnsive Concatenation".

Sorry... Missed Jonathan's post, which appears to be spot on.  Jonathan, how did you figure out it was a rail schedule and where to get the documentation on it?  Is...

The original question was how to import the data without having to use SUBSTRING to do it.  The answer there is to use a BCP Format File along with BULK...