I believe this gets you what you are looking for...

SELECT

s1.LocID,

s1.Name1 as s1Name1,

s1.Name2 as s1Name2,

s2.Name1 as s2Name1,

s2.Name2 as s2Name2

FROM #Server1 s1

JOIN #Server2 s2 ON s2.LocID = s1.LocID

WHERE...

Ed Wagner (10/12/2016)

---

Heavy

45 minute commute depending on traffic. Podcasts has become a lifesaver as I can only listen to music so long. NPR Planet Money is one of my favorites...

Ed Wagner (10/12/2016)

---

Surgeon

Grant, you mentioned Mens Rea in another thread (which is not a term you often hear) and it reminded me of a funny scene from "See No Evil, Hear No...

Grant Fritchey (10/12/2016)

---

Especially true because of a clause in the US law known as Mens Rea, meaning with knowledge. If you knowingly share healthcare information with unqualified people in the...

Luis Cazares (10/11/2016)

---

Y.B. (10/11/2016)

---

Ok, I think I might be going crazy but I've never seem to have any issues with html encoding when posting code before. However, for some...

As an aside, avoid using a leading wildcard in your LIKE (i.e. '%sup%) if possible. You won't be able to make use of any indexes on that column...

Ok, I think I might be going crazy but I've never seem to have any issues with html encoding when posting code before. However, for some reason I'm now...

SQL will do an implicit conversion to a DATETIME data type.

For Example:

DECLARE @myDateTime DATETIME = '2016-10-11'

SELECT @myDateTime

Will get you:

What does you data look like?

You might want to do something...

Parrot

^THIS

As an example I ran similar queries against AdventrureWorks2012.

SELECT

*

FROM

Sales.Customer c

LEFT JOIN Sales.SalesOrderHeader soh ON...

CferMN (10/4/2016)

---

I'm new to index/performance tuning. Could you please explain how to tell what...

drew.allen (10/7/2016)

---

Here is an updated version that only requires a single scan of the table. There is a complete description of the logic at New Solution to the Packing...

Doctor Who 2 (8/7/2016)

---

Eirikur Eiriksson (7/24/2016)

---

Doctor Who 2 (7/24/2016)

---

I finally got my SQL Server database uploaded into Azure SQL! I posted a blog post about it. Rather than repeat what...