sorry it's taken a few days to get back to you.

I suspect it not actually anything to do with the result set. Double check your SQL statement is correct.

When I put the wrong syntax or value, I got an error message complaining about the result set, when in actual fact I had an error in my T-SQL syntax