{"version":"1.0","provider_name":"","provider_url":"https:\/\/www.w3computing.com\/sqlserver2012","author_name":"w3compadmin","author_url":"https:\/\/www.w3computing.com\/sqlserver2012\/author\/w3compadmin\/","title":"Common Table Expressions and Recursive Queries","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"m09Rhk2wU3\"><a href=\"https:\/\/www.w3computing.com\/sqlserver2012\/common-table-expressions-recursive-queries\/\">Common Table Expressions and Recursive Queries<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/www.w3computing.com\/sqlserver2012\/common-table-expressions-recursive-queries\/embed\/#?secret=m09Rhk2wU3\" width=\"600\" height=\"338\" title=\"&#8220;Common Table Expressions and Recursive Queries&#8221; &#8212; \" data-secret=\"m09Rhk2wU3\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script>\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n\/\/# sourceURL=https:\/\/www.w3computing.com\/sqlserver2012\/wp-includes\/js\/wp-embed.min.js\n<\/script>\n","description":"You can use Common Table Expressions to implement recursion because CTEs can contain references to themselves. The recursive member uses the query result of the first invocation. After that, the system repeatedly invokes the recursive part.","thumbnail_url":"http:\/\/www.w3computing.com\/sqlserver2012\/wp-content\/uploads\/sites\/5\/2018\/04\/6.1-Presentation-airplane-parts-300x92.png"}