Why are If statements in SQL being run even when false?

[Bryan]

We have a stored procedure that is supposed to run other stored procedures based on a parameter that gets set by the first stored procedure. However, while everything works fine in the Microsoft SQL Server Management Studio, when the stored procedure is run through the report, the very first if statement is run instead of the correct if statement.

[Todor]

Hello Bryan,

Generally, the Reporting engine doesn't know anything about the Stored Procedures and is not responsible for executing them. The entire process of connecting to the database and executing the query or Stored Procedure is controlled by the data provider specified in the corresponding SqlDataSource component. Our code passes the connection string, parameters, and query/Stored Procedure name, and leaves the rest to the data provider. The default one is 'System.Data.SqlClient'.

Can you elaborate on the workflow? How do you pass the parameter values between the Stored Procedures?

If you use temp tables, you may find useful also the KB article Configuring Stored Procedure with Temporary Tables.

Regards,
Todor
Progress Telerik