Reported as spam

Interesting - does this work out faster than using the REPLACE function?

;WITH N1 (n) AS (SELECT 1 UNION ALL SELECT 1),

N2 (n)...

Brandie Tarvin (5/16/2016)

---

Regarding the federal guidelines for bathroom use... I didn't want to start a fight on The Thread. I posted the news because I thought it was good news,...

Have you tried this?

;WITH

CTE1 AS (

SELECT [Emp_no.], Org_Code, Org_Num FROM #Employee

EXCEPT

SELECT [Emp_no.], Org_Code, Org_Num FROM #Class

), CTE2 AS (

SELECT [Emp_no.], Org_Code, Org_Num FROM #Class

EXCEPT

SELECT [Emp_no.], Org_Code,...

Luis Cazares (5/13/2016)

---

ChrisM@Work (5/13/2016)

---

Sean Lange (5/13/2016)

---

Brandie Tarvin (5/13/2016)

---

For those who hadn't heard, THIS happened.

Yay.

EDIT: I should add I'm not trying to start a debate. I just wanted to pass along...

Sean Lange (5/13/2016)

---

IMHO people...

rk1980factor (5/13/2016)

---

Looks like this query displays the correct result but it display on separate window. i want one query which will show me one result:

SELECT [Emp_no.], Org_Code, Org_Num FROM #Employee

EXCEPT...

Death by function!

Functions are overused in this query. The two most significant consequences are obfuscation, which is sometimes good but not...

On the same server? Then use three-part naming....

rk1980factor (5/12/2016)

---

1) I was referring to following query which you suggested to resolve the original problem at the top in the first post, this query does not solve the problem

SELECT...

rk1980factor (5/12/2016)

---

this query is incorrect, looks like you mixed up org_code with city

also beside that it gives me emp_no : 43232 in the result which is incorrect since combination of...

-- get rows which are unique to Employee:

SELECT Emp_no, Org_Code, Org_Num FROM [dbo].[Employee]

EXCEPT

SELECT Emp_no, Org_Code, Org_Num FROM [dbo].[Class]

-- get rows which are unique to Class:

SELECT Emp_no, Org_Code, Org_Num FROM...

BLOB_EATER (5/12/2016)

---

Is it wrong that I no longer have the desire to do SQL certification exams? Do I need to look in the mirror and slap myself very hard?

Don't...

It's an estimated plan - can you post an actual plan?

Sean Lange (5/10/2016)

---

ChrisM@Work (5/10/2016)

---

Sean Lange (5/10/2016)

---

ChrisM@Work (5/10/2016)

---

Sean Lange (5/9/2016)

---

So I brought back some yummy foods from New Orleans. I got some crawfish and pork sausage, some gator and pork sausage...