Assuming that the data is "regular" in that it will always have the same "fields" to be converted to columns available, this data should never have made it into a single...

You also have to ensure that the machine is learning what is actually necessary.  I recently bought a new Chevy Silverado and the amount of SPAM I now get about...

A brute force method would be to BCP the results out in "Native" format and import it at the receiver.  Numerically based columns such as INT, BIGINT, and DATETIME (etc,...

Heh... I wonder how many people actually know how bad their system currently is when they take that first baseline.  I also wonder if they actually do anything about it...

Like...

Is there any guarantee that ALL of the numeric characters will ALWAYS be contiguous in EVERY string?

Great.  Ya just gotta love some of the intrinsic functions.  Thanks for the feedback.

I'm at work and don't have the time to test right now nor the code that I used previously but you don't actually need a certificate for this type of...