Not sure what you're after... didn't you just use a single command?

Um.... SQL Server 2000 doesn't have the full compliment of RegEx operators, so I'm pretty sure that won't work.

jastarling (4/4/2008)

---

OK, so if I'm understanding you correctly, the column headers need to match the delimiters as the data rows in the CSV file?

Based on that, I changed the...

Guess I'm the oddity...

I say "S-Q-L" Server because my original SQL Mentor would smack me in the head if I said "SeQueL".

I also say "Column", not "Field".

I also say...

I see that the not so uncommon thing has occurred... Matt beat me to it 😀

In the at the very top of the "left window" for each post (just above where you got my posting stats from), just click on my bolded name... new menu...

Matt Miller (4/4/2008)

---

ALZDBA (4/3/2008)

---

Dynamic paging ... :Whistling:

In my SSC-forum-profile...

I haven't checked the entire BCP format file, but the delimiters for the first 4 columns are good...

The problem is with the 3rd column of the HEADER (not the...

Great link... thanks, Gus!

J (4/3/2008)

---

What I' was a little bit worried about is that the myTempSelectionList table would appear to become a hot spot and possibly a source of deadlocks unless you're very...

You say it isn't working at all... do you get any kind of an error message?

More on the above... try solving the running total problem in 3 or 4 different RDBMS engines... and still have some scalability and performance left over.

Portability? Have you ever tried to make 100% portable code and still have it actually do something more than return data to a GUI with simple SELECTs? Even...

I agree... like I said, not sure why I even posted the implicit code... I don't trust defaults for the same reasons you don't.

Very good point.

Actually, I'm not even sure why I posted the implicit conversion code... Implicit conversions constitute a "default" of sorts and I've seen MS change a couple of defaults...