The WHERE NOT EXISTS () construction often performs better than using a LEFT JOIN – I would recommend a test.

You should include table schemas in your code to avoid the...

Why would the Id be the same as the ZipCode?

Script Component Source is where I would start, yes ...

Grumpy DBA (1/14/2016)

---

Luis Cazares (1/14/2016)

---

Phil Parkin (1/14/2016)

---

Grumpy DBA (1/14/2016)

---

Another death, actor Alan Rickman (of Professor Snape and Die Hard fame) died at the age of 69 - oddly the same...

sqlnewbie17 (1/14/2016)

---

If my result set has a million rows wouldn't a case statement be very slow than a where clause.

Is there a better way of doing this.My environment is sqlserver...

Are you opening a VS solution which includes the package? Or attempting to open the dtsx directly?

Remove the where clause.

Add a column to your select

Iif (Cola >Colb, 'true','false')

Grumpy DBA (1/14/2016)

---

Another death, actor Alan Rickman (of Professor Snape and Die Hard fame) died at the age of 69 - oddly the same age as David Bowie. This...

I disagree. Well, it may be what you are looking for, but it does not match your original requirement.

In order...

PearlJammer1 (1/14/2016)

---

Its a good question. I have just asked the same question regarding the data type changing at any point and I am waiting for an answer. This is a...

I would say yes. But as this is a job, presumably it was working before? Or has the proc definition changed recently?

Did you try putting your DISTINCT on the nested SELECT?

monilps (1/13/2016)

---

Hey Phil,

The query is close by what I am looking for but two things:

- Query is only resulting back original rows which has similar duplicate data.

- What if data...

This fits your example data. But is it too specific for your real-world data?

if OBJECT_ID('tempdb..#dupes') is not null

drop table #dupes;

create table #dupes ( Id int identity (1,1) primary...

I'm sorry, but your vague single-sentence responses are not providing the level of clarity required to answer such a complex...