cte

  1. D

    VBA code for CTE Recursive in SQL Data table

    Hi, I have Data table which has data as shown below In this I need to get the "Component" data which are structured under "Item" and after that each component will be considered as "Item" and recursive CTE comes here. Please help me to sort this out. Sample Input: Sample Output in...
  2. M

    Converting MSSQL CTE query to access?

    I had this query formulated that was based off of a query through MSSQL and has CTE expressions which are not compatible with access I guess? I am a noob with Access and SQL. Is there a way to recreate this query but with compatibility with Access? WITH CTE as ( SELECT SHIPMENT_XID,Original...
  3. R

    SQL CTE code disappear

    Hello, I am quite new to sql and am having some issues with a code i have written using microsoft query. I wrote 2 CTEs and it works great but once imported to Excel if i try and go back to the query section, the code has disappeared. I even tried a singular basic CTE and the same thing...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top