CTE in MERGE

• kapil_kk

  SSC-Insane

  Points: 21316

  More actions

  August 27, 2013 at 7:01 am

  #279099

  Can we use CTE in MERGE statement ?

  If possible then please post a sample code of that...

  _______________________________________________________________
  To get quick answer follow this link:
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

• Koen Verbeeck

  SSC Guru

  Points: 259125

  More actions

  August 27, 2013 at 7:02 am

  #1645166

  You use the CTE before the MERGE statement.

  WITH myCTE AS

  (

  ...

  )

  MERGE ...

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP