According to the explanation - I think that 3rd query shall be about table, not about index:

WHERE i.name = 'Tab1'

Right way is:

merge into B dest

using CTE src on src.id = dest.id

when not matched by target and src.RowNo = 1

then insert (id, val) values (id, val);

So I lost the space before 🙂

It changes everything! :w00t:

Thx

How to count spaces on the image? !#$%!$^@#$%@!

Can you tell me what was the right count of spaces in this example?

I did it but it returns 4,4,3. So the answer was wrong!

set ansi_padding on;

go

create table #q (v varchar(5) );

go

insert into #q

select 'ABC' UNION ALL

select 'ABC ' UNION ALL

select 'ABC...