SQL Query Tag Issue

Ignition
3

Check to make sure you have this line at the beginning of the stored procedure:
SET NOCOUNT ON;

Otherwise it returns two datasets, the first being a count of records affected, the second being your actual data. Here’s a sp i just created to test:

[code]CREATE PROCEDURE QueryTagResult
@x int
,@y int

AS
BEGIN
SET NOCOUNT ON;

select @x + @y as 'value'

END
GO[/code]

And for my SQL Query Tag, I have this as my statement:

execute QueryTagResult 2,3

Make sure the Query Type is set to “Select”
Hope that helps!