Viewing 5 posts - 1 through 5 (of 5 total)
According to the explanation - I think that 3rd query shall be about table, not about index:
WHERE i.name = 'Tab1'
December 3, 2013 at 5:47 am
#1670354
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);
February 15, 2013 at 2:37 am
#1588246
So I lost the space before 🙂
It changes everything! :w00t:
Thx
December 22, 2011 at 3:58 am
#1424693
How to count spaces on the image? !#$%!$^@#$%@!
Can you tell me what was the right count of spaces in this example?
December 22, 2011 at 3:02 am
#1424652
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) );
insert into #q
select 'ABC' UNION ALL
select 'ABC ' UNION ALL
select 'ABC...
December 22, 2011 at 1:54 am
#1424625