Updating a CTE

• J-232672

  Valued Member

  Points: 59

  More actions

  June 27, 2008 at 6:08 am

  #193914

  Hello,

  I have a CTE and wish to update it. Is this possible?

  I want the UPDATE to work recursively for all the records in the CTE? is this possible.

  Kindly help.

  Regards,

  meatssc

• chatwithkrishan

  Ten Centuries

  Points: 1056

  More actions

  March 4, 2011 at 9:27 am

  #1294749

  In this case, use Temp table.

  suppose you try to update CTE, It will update the source table value. it will lead data loss.