topic Re: INSERT is not a supported statement type in Data Warehouse

INSERT is not a supported statement type

cubansalsa — Fri, 22 Mar 2024 14:00:49 GMT

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 supported.

DROP PROCEDURE IF EXISTS [dbo].[Daily_Load_Daily_Enrollment_v1]

CREATE PROCEDURE [dbo].[Daily_Load_Daily_Enrollment_v1]

-- Add the parameters for the stored procedure here

--DECLARE @load_date DATETIME = getdate()

BEGIN

-- SET NOCOUNT ON added to prevent extra result sets from interfering with SELECT statements.

SET NOCOUNT ON;

/**** This is for open enrollment dates ****/

DECLARE @Date DATE

SET @Date = CONVERT(DATE,GETDATE()-1)

;WITH FIND_TERM AS

(

SELECT DISTINCT A.EMPLID,

A.STRM,

A.ACAD_CAREER,

A.CLASS_NBR,

A.UNT_PRGRSS,

A.STDNT_ENRL_STATUS,

TR.TERM_BEGIN_DT,

TR.TERM_END_DT,

@Date AS 'Enrollment_Date'

FROM (SELECT EMPLID, STRM, ACAD_CAREER, CLASS_NBR, UNT_PRGRSS, STDNT_ENRL_STATUS

FROM Student_Data.dbo.cs_PS_STDNT_ENRL

WHERE STRM >= '2217'

AND STDNT_ENRL_STATUS = 'E'

AND ACAD_CAREER <> 'CEPD'

AND GRADING_BASIS_ENRL <> 'NON'

) A

LEFT JOIN Student_Data.dbo.cs_PS_TERM_TBL TR

ON A.STRM = TR.STRM

AND TR.ACAD_CAREER = 'UGRD'

INNER JOIN Student_Data.dbo.cs_PS_SESSION_TBL S

ON TR.STRM = S.STRM

AND TR.TERM_BEGIN_DT = S.SESS_BEGIN_DT

AND TR.TERM_END_DT = S.SESS_END_DT

WHERE @Date BETWEEN S.FIRST_ENRL_DT AND S.SESS_END_DT

)SELECT * FROM FIND_TERM

Re: INSERT is not a supported statement type

Anonymous — Mon, 25 Mar 2024 03:50:32 GMT

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.

Re: INSERT is not a supported statement type

Anonymous — Tue, 26 Mar 2024 13:44:40 GMT

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.

Re: INSERT is not a supported statement type

cubansalsa — Tue, 26 Mar 2024 14:08:24 GMT

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.

Re: INSERT is not a supported statement type

Anonymous — Wed, 27 Mar 2024 09:45:45 GMT

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?

Re: INSERT is not a supported statement type

cubansalsa — Wed, 27 Mar 2024 14:16:47 GMT

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

Re: INSERT is not a supported statement type

Anonymous — Wed, 27 Mar 2024 14:48:58 GMT

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.