Comentários (5)

1 YONGLEIG comentou às Link permanente

*pretty* plan, smilence

2 AndrejFurlanič comentou às Link permanente

I did some tests with merge statement. Samples are best way to learn. Finally, i couldn't resolve the errors with the following syntax:

 
select * from new/old/final table (merge ...)
 
Any plans to support this syntax ?

3 SergeRielau comentou às Link permanente

Andrej,

 
I'm waiting for the right excuse to put it into plan....
The potential for select from merge is huge.
 
Cheers
Serge

4 EmberCrooks comentou às Link permanente

Serge, can I use Common Table Expressions ('with (...) select...') in the using clause of a merge statement?

5 SergeRielau comentou às Link permanente

Ember,

 
Unfortunately you cannot.
The only place where you can do WITH clause inside a statement is INSERT and the RETURN statement of an SQL Table function.
The later could serve as a work around in your case.
 
Cheers
Serge