SQL CTE code disappear

[rebeccawilson100]

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 happens. I've been looking on google but have not found an answer or reason as to why it does this.

Any ideas?

Thanks

Rebecca

 

[GJSBED]

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 happens. I've been looking on google but have not found an answer or reason as to why it does this.

Any ideas?

Thanks

Rebecca

How are you importing it as Text or as data from Microsoft Query

If its the latter (the best way) then the within the connection properties of the table (data ribbon) exported you can get to a tab called definition within which sits the command text (the sql) which can be edited via the edit query button which takes you back to the MS Query window.

 

[rebeccawilson100]

I think i am importing it as data. The way i am getting back to the sql it right click on the table -> table -> Edit query. I have used this process in the past for different queries and been able to go back to the sql code behind it. But as soon as I write a CTE i can't go back to the code.

Forgive me if i'm making really basic mistakes or talking jibberish.