Yes, that's because SELECT INTO attempts...

Had an interview on Monday morning which I thought went quite well until the last two questions:

1) Where do you see yourself in 5 years time?

2) Your salary expectations for...

If the target table already exists then you would need to use INSERT INTO

I always prefer to list the column names in my INSERT INTO and SELECT statements, however you...

Is it?

So what happens if I have two records with the same Organisationname but the address1 of...

Jeff Moden (1/27/2014)

---

I haven't checked for all of the columns but the original query had a "Hierarchy" column in it, which is missing from the test data. Considering that...

GilaMonster (1/28/2014)

---

Abu Dina (1/28/2014)

---

David Webb-CDS (1/27/2014)

---

I'm afraid you're asking for code that would make these two:

21ST CENTURY SERIVES

21ST CENTURY SERVICES

equal, not because they are, but because they SHOULD be. ...

ChrisM@Work (1/27/2014)

---

Check the actual plan of each to ensure you're getting an index scan on one side and seeks on the other and check the nested loops join operator carefully...

David Webb-CDS (1/27/2014)

---

I'm afraid you're asking for code that would make these two:

21ST CENTURY SERIVES

21ST CENTURY SERVICES

equal, not because they are, but because they SHOULD be. Is that true?...

TheSQLGuru (1/27/2014)

---

We asked specifically (several times) for your expected OUTPUT too.

In particular, I am unclear on this statement:

and your task is to add a new column...

As requested, sample data below:

The goal is to dedupe the list of 200 records at Site level. A site being company + address.

I look forward to see how you guys...

Another way is to copy the run the contents of the below SELECT statement:

SELECT 'SELECT DISTINCT [' + COLUMN_NAME + '] FROM ' + TABLE_NAME

FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME...

ChrisM@Work (1/27/2014)

---

They're very narrow triangles - having dealt with this in the near past. Nevertheless, with two of them ORred together, the optimiser will likely choke. Try splitting them up...

GilaMonster (1/27/2014)

---

As for avoiding blocking, that's easy, use...

Please share your secret!

Source table looks like the below:

CREATE TABLE [dbo].[TheTable](

[ID] [int] IDENTITY(1,1)...

Record linkage once again!

Here I'm looking for records that have the same address! I need to run this query so I can generate a Site ID per record.