I heard a great joke for nerds (I was about to call it "nerd joke", but it's for nerds, not about nerds) this weekend:

Why do computer science majors always confuse...

dwain.c (6/2/2013)

---

Hi again Wolf Kill.

I just wanted you to know that I am not trying to be rude by not letting you know if your suggestion worked.

I sent some suggested...

AndrewSQLDBA (5/28/2013)

---

Good Morning Everyone

I hope that everyone had a very nice weekend.

I am inserting rows from one database to another. The tables that I am using as the source, has...

AndrewSQLDBA (5/28/2013)

---

Good Morning Everyone

I hope that everyone had a very nice weekend.

I am inserting rows from one database to another. The tables that I am using as the source, has...

I think this has to do with the fact that the SQL Agent Service on SQL2 is running under the NT AUTHORITY\SYSTEM account, which is a local account. You should...

This discussion reaffirms my conscious choice not to use BETWEEN in anything other than throwaway queries. It's a bit of syntactical sugar of dubious value - really, how much harder...

Yeah, Lynn, this is why we allow the original...

Brandie Tarvin (5/16/2013)

---

The Dixie Flatline (5/16/2013)

---

But I only mentioned it (that I know...

Hugo Kornelis (5/15/2013)

---

Thanks, all for the kind comments and the valuable discussion.

It's interesting to see how different people have different opinions about BETWEEN. In my experience, this sometimes goes wrong...

The logic embodied in that...

opc.three (5/13/2013)

---

If you are using either Snapshot Isolation or READ COMMITTED SNAPSHOT ISOLATION (RCSI) mode that could account for the behavior you are seeing. My comments are related to the...

opc.three (5/13/2013)

---

The issuance of the IDENTITY column is part of the transaction so we are protected from loss of data.

In SSMS, Query Window 1, run this:

USE YourDatabaseName;

DxROP TABLE dbo.StagingTable

CxREATE TABLE...

opc.three (5/13/2013)

---

wolfkillj (5/13/2013)

---

Jeff Moden (5/10/2013)

---

wolfkillj (5/7/2013)

---

Phil Parkin (5/7/2013)

---

This is probably what you meant by "I can program the loading process in another way, I know." but to remove most of...

Brandie Tarvin (5/13/2013)

---

Exactly. If you check my first post, you'll see...

Brandie,

I couldn't use your sample data because the text file formatting seemed to be inconsistent from line to line, so I made up my own. This solution assumes that...