OK I've found out what a format file is, and have created it using the bcp utility. (Never done that before.)

Now what I don't know how to do is not...

Would that format file be my .CSV file? And the source and destination columns would be the first row of the .CSV file? If so, then I'd better go back...

Ok Ed, I've got a question and an observation.

First the observation. I didn't know it when I wrote the SQL BULK INSERT script, but that must be run on the...

Ed Wagner (9/11/2015)

---

If this is a one-time activity, you can query the rows in SSMS and save them as a CSV file by right-clicking the results pane...Save As and select...

I believe we do have an ER diagram somewhere, but I don't maintain it. I'm a part of a bigger IT/dev group now, with more specialization. The tool they're using...

Wayne West (8/31/2015)

---

Wow, a 35,000 word article? That's a short story! It took me pretty much a full day to read it! (don't tell my boss)

It had a...

Wayne West (8/26/2015)

---

Rod, if your database's front end is Microsoft Access, or if people are using Access against it, you might want to keep it. Access likes rowversion to...

An excellent article, Steve. Like others have said I'm going to read the Bloomberg article later; can't now as I'm at work. But your article reminds me of a problem...

Late yesterday I had the same thought, Tom. i.e.: why not chance the constraint to use cascading deletes? In fact, at least from my point of view that makes more...

Jeff Moden (8/25/2015)

---

sgmunson (8/25/2015)

---

Rod at work (8/24/2015)

---

Hmmm. Thank you Grant, I really appreciate the straight forward explanation for what the rowversion/timestamp is all about. I'm working on archiving the data,...

The weird this is I tried reversing the order - i.e.: deleting the data from PharmInvOutItemPackageReceipts first, but that didn't help. I got the same error message. However you've given...

Hmmm. Thank you Grant, I really appreciate the straight forward explanation for what the rowversion/timestamp is all about. I'm working on archiving the data, but leaving it in the database...

Matt Miller (#4) (8/20/2015)

---

Stephanie J Brown (8/18/2015)

---

Eric M Russell (8/18/2015)

---

Like I said earlier, if estimating is part guesswork, then the business should be the one providing the guesses. The business...

ZETM (8/18/2015)

---

Sometimes you get pushed out of jobs. Projects comes to an end, bean counters go to the boss and whisper in the ear on how much the IT...

Oh OK Luis, I get it now. I got hung up on trying to read what's in syscolumn. That's not the point at all, is it. The original poster is...