# SQL statement did not return a result set error

**URL:** <https://forum.inductiveautomation.com/t/sql-statement-did-not-return-a-result-set-error/23105>\
**Category:** Ignition\
**Created:** [March 6, 2019, 10:23pm UTC](https://forum.inductiveautomation.com/t/sql-statement-did-not-return-a-result-set-error/23105 "2019-03-06T22:23:47Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Tim](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/tim/32/3361_2.png) [@Tim](https://forum.inductiveautomation.com/u/Tim)\
**Post date:** [March 6, 2019, 10:23pm UTC](https://forum.inductiveautomation.com/t/sql-statement-did-not-return-a-result-set-error/23105/1 "2019-03-06T22:23:47Z")

</div>

When running this MS SQL on a table data binding I receive an error:  
GatewayException: The statement did not return a result set.  
SQLServerException: The statement did not return a result set.

The query runs correctly in Management Studio and returns results. Suggestions? Do I need to run from a stored procedure?

```auto
DECLARE @DynamicPivotQuery AS NVARCHAR(MAX)
DECLARE @ColumnName AS NVARCHAR(MAX)
 
SELECT CAST(TimeComplete AS DATE) [Date], 
   DATEPART(hour,TimeComplete) [Hour], Count(1) [Production Count]   
    INTO #PivotData
FROM Table
GROUP BY CAST(TimeComplete AS DATE), DATEPART(hour,TimeComplete)

--Get distinct values of the PIVOT Column 
SELECT @ColumnName= ISNULL(@ColumnName + ',','') 
       + QUOTENAME([Date])
FROM (SELECT DISTINCT [Date] FROM #PivotData) AS Dates

--Prepare the PIVOT query using the dynamic 
SET @DynamicPivotQuery = 
  N'SELECT [Hour], ' + @ColumnName + '
    FROM #PivotData
    PIVOT(SUM( [Production Count] ) 
          FOR [Date] IN (' + @ColumnName + ')) AS PVTTable'
--Execute the Dynamic Pivot Query
EXEC sp_executesql @DynamicPivotQuery
```

---

<div class="post-metadata">

**Author:** ![c.bertulli](https://avatars.discourse-cdn.com/v4/letter/c/f19dbf/32.png) [@c.bertulli](https://forum.inductiveautomation.com/u/c.bertulli)\
**Post date:** [March 7, 2019, 10:40am UTC](https://forum.inductiveautomation.com/t/sql-statement-did-not-return-a-result-set-error/23105/2 "2019-03-07T10:40:55Z")

</div>

I think you should put your stored procedure inside the Management Studio then call it from commands `system.db.createSProcCall() system.db.execSProcCall()`

---

<div class="post-metadata">

**Author:** ![dkhayes117](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dkhayes117/32/68344_2.png) [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\
**Post date:** [March 7, 2019, 1:07pm UTC](https://forum.inductiveautomation.com/t/sql-statement-did-not-return-a-result-set-error/23105/3 "2019-03-07T13:07:06Z")

</div>

Yep, you need to make this a stored procedure call. The JDBC drivers do not work with declaring variables or with multiple statements.