When sql-proc returns multiple datasets - Lucee returns error. “The key [SP_HELP_RES5] does not exist, but there is a similar key with name [sp_help_res1] available.“
That happens only with newer mssql drivers from 7.2.0. With 6.4.0.jre8 works well.
Microsoft SQL Server (Vendor Microsoft) Driver - 7.2.0 - 7.2.2
I've checked this ticket & confirmed the issue happened on the extension MSSQL - 7.2.2.jre8 version. Both the ( 6.4.0.jre8 and 7.2.2.jre8 ) version results are different. And it throws an error as you said. I made a test with your code. but, it returns results are based upon your table. So, some difference has from both above versions. So, Micha will confirm about this issue.