Christopher Columbus,... challenges his critics to make an egg stand on its tip. After his challengers give...

At the time of Columbus there was no Gregorian calendar, so Columbus does/did not have to account for this.

For the last 3000 years the days of the week have followed...

As often within software errors, once introduced are very difficult to eliminate. We rather define the reality as wrong and keep software 'bug'...

There were still some questions asked, I'll try to anwser them briefly.

Sergiy (7/26/2016)

---

Our suppliers were kind enough to agree on a protocol where EOL within a "Product Description" or "delivery...

John Mitchell-245523 (8/2/2016)

---

Perhaps we can all agree on the following?

* This is of far more interest to us than it is to the original poster, who hasn't been seen here...

Sergiy (8/1/2016)

---

Dates do not have format stored...

Luis Cazares (7/22/2016)

---

ben.brugman (7/22/2016)

---

This is a bit 'short' I would guess:

SELECT DATEADD(month,12*(YEAR('20160401')-1902)+3,0) -- Result 2014-04-01 00:00:00.000

SELECT DATEADD(month,12*(YEAR('20160331')-1902)+3,0) ...

This is a bit 'short' I would guess:

SELECT DATEADD(month,12*(YEAR('20160401')-1902)+3,0) -- Result 2014-04-01 00:00:00.000

SELECT DATEADD(month,12*(YEAR('20160331')-1902)+3,0) -- Oops...

Oops

Dates definitively have a format when they are stored in the database.

This format partly determines what you can do...

GSquared (7/20/2016)

---

I built something very similar, but it uses XML instead of EAV, and NULLs out empty columns. Used less space and XML parsing was faster than EAV reconstitution....

Sergiy (7/19/2016)

---

So then I have some questions, because I am still strugling with parts of the code.

How do you handle EOL within fields? (Or a bit...

GSquared (7/19/2016)

---

How are you doing the CSV imports? OpenRowset? Linked servers? BCP?

For most of those, you need to have the file definition already in-place.

If you're pulling data...

Sergiy (7/19/2016)

---

Because it's not a single-user environment.

Because a process can be delayed, another file can arrive before the previous one is done.

Because - see your starting topic.

You listed there several...

Why ?

One of the obvious ones - create static tables...