kandukurivarun

This is the query/sproc that i am executing: ` DECLARE @output NVARCHAR(MAX) EXEC getAppInstanceHieraData @output OUT SELECT * FROM OPENJSON(@output) WITH ( AttributeId INT '$.LabelId', AttributeKey NVARCHAR(MAX) '$.AttributeKey', AttributeValue NVARCHAR(MAX)...

And the affected_rows returns '-1'

Sometimes i am getting the below error: `TinyTds::Error: Attempt to initiate a new Adaptive Server operation with results pending from (irb):25:in `execute' from (irb):25 from /opt/puppetlabs/puppet/bin/irb:11:in `'`

Is there a way to enable the debugging on this library query execution? Same query working properly on SSMS and returns null on Ruby .

I have added the 'Select @output' to the end of my query and still it doesn't work. It just returns null.

This is what i got when i executed it with the way that you shown above: `irb(main):088:0> client.execute(query).do SELECT @result = FQDN FROM tblAppInstanceServer ais LEFT JOIN tblAppInstance tAI on...

I know what is happening, the SPROC consists of plenty of select statements. When i use tiny_tds, it is trying to execute the 1st select statement from the sproc and...

SSMS knows that it has to wait till it executes all statements in the sproc, but tiny_tds exits after it execute the first select statement. How i can fix this...

Below is the results pane from SSMS 

I am seeing the output i am expecting on `tsql`