Sure, for a small fee 😀

My attempt:

create table test (Attribute1 char(1), attribute2 char(1), attribute3 char(1), thetimestamp datetime)

insert into test(Attribute1, attribute2, attribute3, thetimestamp)

select 'A', 'B', 'C', '2013-09-02 16:06:30' union all

select 'A', 'B', 'C', '2013-09-02 16:06:35' union...

You no longer MCM?!

waxb18 (8/30/2013)

---

Good Morning All,

Just a quick question...

I have a table which updates on a daily basis after 11pm when no-one is here.

Is it good practise to have the indexes build...

Well then your other option is to include this in a case statement in your SELECT

Something like this:

SELECT

CASE WHEN [NAMES] like '%[A-Z]S.R.L.%' THEN REPLACE(Names, 'S.R.L.', ' S.R.L.') ELSE [NAMES] END,...

Can you update the Names column in your T40 table?

UPDATE T40

SET Names = REPLACE(Names, 'S.R.L.', ' S.R.L.')

WHERE Names LIKE '%[A-Z]S.R.L.%'

Sorry Chris 😛

Well, I've taken a slightly different approach as I can't seem to work out this puzzle. I know this is an ugly way of solving the problem but...

My bad, the latest actual execution plan is for match key type 13, it looks like I generated an actual execution plan for a different match key type before!

Good point about the data types. These have been changed to match the data type of the match key.

Have a look at this though:

Running the below (notice the TOP operator)...

Thanks for this Chris.

I've run my original code again to get the actual execution plan (attached below). Interestingly my original query ran in 15 seconds to produce 234990 records but...

I've also tried materialising the result set of the below query into a table:

SELECT a.RecordID AS Master_ID,

b.RecordID AS Duplicate_ID,

a.Forename AS Master_Forename, b.Forename AS Duplicate_Forename

FROM MyTable AS a

INNER JOIN MyTable AS...

Okay I will try again with a simpler version of my problem.

Say I have the following table records:

In order to look for duplicates I create hash keys (converted to BIG...

I don't think its a problem with the code, it's the data that I'm using it's a mess!

Thanks for this but I'm still getting this error. To be honest I don't even have to use the MERGE statement for this. I just want to be able to...

Sure!

INSERT INTO TargetTable (Uarn, BACode, VO_Ref, From_Date, To_Date)

SELECT Uarn, BACode, VO_Ref, From_Date, To_Date

FROM

(

MERGE TargetTable AS tgt

...