Creating SQL Stored Procedures via SQL Server is easier than you might have originally thought, so let us explain what to do. Simply follow the steps here: Click on New Query ...

While nothing can fix the first problem (short of a different BA), the second problem can be simplified in code. The examples below show how to replace multiple stored procedure parameters using ...