I haven’t worked with stored procedures before, inside or outside of Ignition.
Have been given one to setup, have attached a text file with the SP, errors I get trying to run in database browser. Then tried a script to call it, and I get 36 columns returned but 0 rows, the other attchement comes from MS SQL Mgmt Studio, it has 36 columns too so appears I am getting close.
Thought the error might have been that it was returning two datasets, so split the SP into _A and _B but get the same errors.
First thing tried was checking this was off: Microsoft SQL Server - "Result set was generated for update"
Edit: UltimatelyI will need the barcode coming in with ? placeholder