79500195

Date: 2025-03-11 09:30:50
Score: 3
Natty:
Report link

The solution for first problem was to give the parameters a value when calling the report and not to rely on the defined default value.

For the second problem the solution was to REPLACE their position in the SQL query:

execute MyServer.MyDB.MyProc @Param2, @Param1, @Param3.

Then @Param1 and @Param2 got the right values.

Reasons:
  • No code block (0.5):
  • User mentioned (1): @Param2
  • User mentioned (0): @Param1
  • User mentioned (0): @Param3
  • User mentioned (0): @Param1
  • User mentioned (0): @Param2
  • Self-answer (0.5):
  • Low reputation (1):
Posted by: Shabtay Fischer