SQL Query Returns Different Results MSSQL vs Database Query Browser

Ignition
2

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