Error - Select statement did not produce a ResultSet for native query

1

Hi there - facing issue with using SQL temp tables in a stored procedure which I executed in Metabase
I get this error message - "Select statement did not produce a ResultSet for native query" Following is my stored procedure

CREATE  PROCEDURE Demo_GetDepartments
AS

CREATE TABLE  #Departments
( Departmentid INT
 , Name VARCHAR (50) )

INSERT INTO  #Departments
SELECT DepartmentID ,  [Name]
FROM  Departments 

SELECT  * FROM  #Departments

Thanks!

2

Hi @sgayathri
You cannot execute write queries in Metabase, nor multi-statement queries.
https://github.com/metabase/metabase/issues/4050 - upvote by clicking :+1: on the first post