How can I return SQL Server SP result(Dataset) directly into ignition 7.9 tag or table

[PGriffith]

Try declaring the NOCOUNT parameter in your stored procedure:

SQL Query Returns Different Results MSSQL vs Database Query Browser

In your stored procedure you need to add the line “SET NOCOUNT ON;” to the immediate beginning. 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

This is often an issue with MSSQL; Management Studio connects to the database in a different 'mode' than Ignition does by default.