# SQL Query Returns Different Results MSSQL vs Database Query Browser

**URL:** <https://forum.inductiveautomation.com/t/sql-query-returns-different-results-mssql-vs-database-query-browser/29002>\
**Category:** Ignition\
**Created:** [October 10, 2019, 6:45pm UTC](https://forum.inductiveautomation.com/t/sql-query-returns-different-results-mssql-vs-database-query-browser/29002 "2019-10-10T18:45:56Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![jlopez](https://avatars.discourse-cdn.com/v4/letter/j/aeb1de/32.png) [@jlopez](https://forum.inductiveautomation.com/u/jlopez)\
**Post date:** [October 10, 2019, 6:45pm UTC](https://forum.inductiveautomation.com/t/sql-query-returns-different-results-mssql-vs-database-query-browser/29002/1 "2019-10-10T18:45:56Z")

</div>

I have a stored procedure named GetRowNumforFace constructed as follows:

> USE [solidiadb]  
> GO  
> /\*\*\*\*\*\* Object: StoredProcedure [dbo].[GetRowNumforFace] Script Date: 10/10/2019 1:34:59 PM \*\*\*\*\*\*/  
> SET ANSI\_NULLS ON  
> GO  
> SET QUOTED\_IDENTIFIER ON  
> GO  
> ALTER PROCEDURE [dbo].[GetRowNumforFace] @BatchID int  
> AS
> 
> DECLARE @faces AS varchar(50);  
> SET @faces = (SELECT ChildFaceMixID\_new FROM BatchSheetGeneral WHERE BatchSheetID = @BatchID);
> 
> DECLARE @sql AS nvarchar(MAX);  
> SET @sql = 'SELECT t.row\_num  
> FROM (  
> SELECT ROW\_NUMBER() OVER(ORDER BY BatchSheetID DESC) - 1 AS row\_num, BatchSheetID  
> FROM BatchSheetGeneral  
> WHERE UseTypeID = 2 AND activeflag = 1  
> ) t  
> WHERE t.BatchSheetID IN ('+@faces+')';
> 
> DECLARE @tmpTbl TABLE(row\_num int);  
> INSERT INTO @tmpTbl EXEC sp\_executesql @sql;
> 
> DECLARE @result AS varchar(MAX);  
> SELECT @result = COALESCE(@result + ',', '') + CAST(row\_num AS varchar(50)) FROM @tmpTbl;  
> SELECT @result AS row\_num;

When I execute the query in MSSQL and Database Query Browser in Ignition I get different results. Basically, when run in Ignition says its an empty result set in a Data binding to custom property and when I run in the database query browser it is in fact empty.

MSSQL:

 ![StoredProcedure_mssql](https://us1.discourse-cdn.com/inductiveautomation/original/2X/5/52a8f6a4bc819886d2bf467506935d69767a7e7f.png)

Ignition:  
 ![StoredProcedure_ignition](https://us1.discourse-cdn.com/inductiveautomation/original/2X/e/e523c85160d8545e99fadab6d657876dcc622782.png)

---

<div class="post-metadata">

**Author:** ![tim.schultz](https://avatars.discourse-cdn.com/v4/letter/t/71e660/32.png) [@tim.schultz](https://forum.inductiveautomation.com/u/tim.schultz)\
**Post date:** [October 10, 2019, 8:03pm UTC](https://forum.inductiveautomation.com/t/sql-query-returns-different-results-mssql-vs-database-query-browser/29002/2 "2019-10-10T20:03:25Z")

</div>

In your stored procedure you need to add the line “SET NOCOUNT ON;” to the immediate beginning.

```auto
ALTER PROCEDURE [dbo].[recordSiloLevel]
	-- Add the parameters for the stored procedure here
	@inputXML as NVARCHAR(MAX)
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;
	-- Your Procedure Here...
END

```

---

<div class="post-metadata">

**Author:** ![jlopez](https://avatars.discourse-cdn.com/v4/letter/j/aeb1de/32.png) [@jlopez](https://forum.inductiveautomation.com/u/jlopez)\
**Post date:** [October 10, 2019, 8:31pm UTC](https://forum.inductiveautomation.com/t/sql-query-returns-different-results-mssql-vs-database-query-browser/29002/3 "2019-10-10T20:31:46Z")

</div>

Thanks Tim! That did the trick!