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

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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi cubansalsa ,

        It might be an Intermittent issue, glad to know that your issue got resolved. Please continue using Fabric Community on your further queries.