Solved

Execute Stored Procedure for a set of values

Posted on 2016-11-21
5
72 Views
Last Modified: 2016-12-27
I have around 10 Stored Procedures each of which takes one argument as an input parameter. I have a table of around 200 ids against which I want to run these 10 stored procedures.  What is the best way of executing this ? Also for each id for each stored procedure run I would like a count of the number of records affected or the stored procedure to return a true or false.

Please let me know if you have any other questions,
Thanks,
Aditya
0
Comment
Question by:giveindia
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 34

Accepted Solution

by:
ste5an earned 500 total points
ID: 41895819
What is the best way of executing this ?
It solely depends on your procedures internals. Whether the order should/could be a(1), b(1), c(1)..a(n), b(n), c(n) or a(1),a(2),a(3)..c(1),c(2),c(3)).

"How to execute this?"
Create a cursor and invoke the methods. Don't think about using dynamic SQL, when you cannot justify its usage.

for each id for each stored procedure run I would like a count of the number of records affected or the stored procedure to return a true or false.
It solely depends on your procedures internals. When the procedures do not expose those numbers, there is no way to get them. Cause to calculate it otherwise means that you need to replay the sprocs internals.
0
 

Author Comment

by:giveindia
ID: 41905326
Nevermind. I handled it through a console application written in .NET.

Thanks,
Aditya
0
 

Author Comment

by:giveindia
ID: 41905473
Nevermind. I handled it through a console application written in .NET.

Thanks,
Aditya
0
 
LVL 34

Expert Comment

by:ste5an
ID: 41905527
You've asked for the best method. Using .Net is not the best method, cause it requires an extra layer in a different technology.

Also my caveat still holds: You cannot rely on the records affected value.
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

724 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question