Yep... don't split it at all... if the format of the file is stable and a couple of other nuances, use Bulk Insert. In SQL Server 2000, I used...

So, what did your final code end up looking like?

Ummm... no.......

Oliver (1/15/2009)

---

No offense intended, it just seems to me that the better path to go is to first try to set the file sizes large enough to deal with most...

I disagree with most of the thoughts on this thread... I've used both and, for what I classify as "casual users" and ease of use, I think that SQL Server...

Let me rephrase my question a bit... add on to it, really...

How are you going to identify the columns that you want to check or are you asking for code...

agh100 (1/15/2009)

---

Hi,

What I need to do is:

Find out which specific rows and columns that contains ascii values below 32, and log it either in a txt file or another db.

So,...

GSquared (1/15/2009)

---

If you actually have to do row-by-row, use a cursor for it. It's what they're built for, and they're good at it. While loops for row-by-row aren't...

That's just nasty... went through that in my last company. Some high level genius at the company bought a...

That's another good one. And, I've never seen it where they need to return an out of scope identity produced by @@IDENTITY... anyone ever actually do that? What...

But, aren't you executing the column merge code once for each "employee"?

And, if you're happy with the speed, then that's what matters. 😀

BWAA-HAA!!...

Any build up on the walls over time?

Ronson Lighter fluid... it's "ashless".

Heh... man, you don't know how close that is......