This will give you what you want.

SELECT A.MemNo

FROM zzz_Overlapping A

JOIN zzz_Overlapping B

ON B.MemNo = A.MemNo

AND ((A.YMDStart BETWEEN B.YMDStart AND B.YMDEnd)

OR (A.YMDEnd BETWEEN B.YMDStart AND B.YMDEnd))

WHERE B.YMDStart !=...

Also, I would expect custid to be a foreign key as well.

There is no need to index foreign keys by default. So long as employees(empid) is indexed, which it should be since the empid column is the primary key of employees...

I'm assuming the goal here is to consolidate multiple OLTP databases into one OLTP database, and each existing line of business application will (at least for now) continue it's own...

Matt Miller (#4) (2/9/2016)

---

Eric M Russell (2/9/2016)

---

...That's scary, though potentially not a problem. A number of states publish voter data as public records. A few might have restrictions on the...

David.Poole (2/9/2016)

---

I heard a story that an analysis of coin composition revealed the state of a nation's armament capability.

Data is like fissile material. Once it gains critical mass it's...

Have you ever wondered how much an IT staff member working for Department of Homeland Security earns?

http://php.app.com/fed_employees11/results.php?fullname=&topagency=DEPARTMENT+OF+HOMELAND+SECURITY&agency_name=%25&job_title=INFORMATION+TECHNOLOGY+MANAGEMENT&statename=%25&Submit=Search

🙂

Steve Jones - SSC Editor (2/9/2016)

---

Eric M Russell (2/9/2016)

---

...That's scary, though potentially not a problem. A number of states publish voter data as public records. A few might have restrictions...

ThomasRushton (2/9/2016)

---

Eric M Russell (2/8/2016)

---

There has been explosion in the number of relational SQL databases developed over the past 20 years. The broad sentiment that RDMS don't scale is due...

...That's scary, though potentially not a problem. A number of states publish voter data as public records. A few might have restrictions on the use of that data, but the...

There has been explosion in the number of relational SQL databases developed over the past 20 years. The broad sentiment that RDMS don't scale is due to the unfortunate fact...

If employees have interesting projects to work on, are well compensated, and generally happy with the direction of the organization, then having a "corporate culture" in place will give them...

Basically what you're describing is the underlying tables of a "distributed partitioned view" design pattern.

https://technet.microsoft.com/en-us/library/ms188299(v=sql.105).aspx

What you'll need to do is have each table insert identity values within a unique range....

Beatrix Kiddo (2/8/2016)

---

Thanks; I hope you're right. I'm very concerned that I'm getting de-skilled here. It's really sad; nobody cares, nobody wants to do anything well, nobody wants to improve...