Forum Discussion

cubansalsa's avatar
cubansalsa
Frequent Visitor
2 years ago
Solved

INSERT is not a supported statement type

I have a Stored Procedure from SQL Server that uses a CTE to insert rows into a Data warehouse table that I want to replicate in Microsoft Fabric. I keep on getting errors that into statement is not...
data warehouse
  • cubansalsa's avatar
    cubansalsa
    2 years ago

    Now it works.  Did you do anything?  Thank you anyway.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hello cubansalsa ,

Thanks for using Fabric Community.
At this time, we are reaching out to the internal team to get some help on this .
We will update you once we hear back from them.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi cubansalsa ,

Can you please confirm above SQL is complete SQL query? As there is nothing in the SQL code that looks problematic and there is no INSERT statement.

  • cubansalsa's avatar
    cubansalsa
    Frequent Visitor
    2 years ago

    It is correct.  Just replace the las select * with select * into.

    or try to use any into stament and you will get the error.

    thank you for looking into this problem.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi cubansalsa ,

      When I tried to repro your scenario, I didn't face any issue.
      I was able to run the query in Data Warehouse without any issues.


      Can you please share the screenshot of your issue? 

      • cubansalsa's avatar
        cubansalsa
        Frequent Visitor
        2 years ago

        Now it works.  Did you do anything?  Thank you anyway.