Post for documentation purposes.
This is when you try to save the table output from a stored procedure to a table in the calling code.
If it was supposed to work in Fabric, on this documentation page:
https://learn.microsoft.com/en-us/sql/t-sql/statements/insert-transact-sql?view=fabric
the 3rd syntax box "-- Syntax for Azure Synapse Analytics and Parallel Data Warehouse and Microsoft Fabric"
would have the line "| execute_statement".
The first syntax box for normal SQL Server does have this line.
I haven't found anything saying if this will be implemented in the future, or if it is decided to never be implemented.
Example code:
CREATE PROCEDURE dbo.testRows
AS
BEGIN
SELECT 1 AS Val;
END;
GO
CREATE TABLE dbo.testRowsTbl (a INT);
-- This INSERT INTO EXEC statement is not valid Fabric Warehouse syntax
INSERT INTO dbo.testRowsTbl (a)
EXEC dbo.testRows;
SELECT * FROM dbo.testRowsTbl;
