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...

OK, this answer contradicts the earlier one.

So ... you want to identify rows where another row exists which is 'similar'.

'Similar' here means that all...

monilps (1/13/2016)

---

Hi,

I need to identify possible duplicate (not exactly duplicate row) data without primary key:

Table A:

Col1 ...

Please explain how the 'customized' figures are determined.