Please check the below points

1. Is your stored procedure working correctly? did you check it in SQL management by executing it with the same parameters?

2. Have you set the correct datatype in the structure in the advanced query(integer /Decimal for return digit value)?

3 did you check if any error throwing by this advanced query in the service center?

I hope you can troubleshoot your issue this way.

Best,
Amit

Hi,

Edward

Once the test the sql and check the result in test output if it is correct  then there is wrong at assign node.

If test sql is returning zero then sql query is wrong.

Next time if you post any question try to give more details about your problem so other will understand you problem.

Hi Edward Muratov,

Use Test Inputs to test your output value and check the Test Output value.

Still getting output value is zero. So need to check your SQL query.

Example:

Thanks,

Ramesh