Forum Discussion
cubansalsa
2 years agoFrequent Visitor
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...
- 2 years ago
Now it works. Did you do anything? Thank you anyway.
Anonymous
2 years agoNot applicable
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
2 years agoFrequent Visitor
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.