Pentaho - statement did not return a result set

Using a TABLE INPUT with a Microsoft Sql Server procedure, I started getting this error message:

"statement did not return a result set"

After some googling and misleading forum threads, I found that the Java Driver was getting confused by the rowcount.

To solve this you need to add SET NOCOUNT ON; at the begining of your procedure.



Check out my new book about R Language http://www.amazon.com/dp/B00SX6WA06