Call a stored procedure multiple times and process only one of the three table which gets returned

Question

1.00/5 (1 vote)

See more:

I am trying to extract data from SQL SERVER 2008 database.Following is the description my task:

1. I have list of records(lets say 100) which I did extract using a SQL query from the database.

2. Some specific columns of each record should be given input to a stored procedure. The stored procedure returns three tables as the output.

3. I will have to catch only one of the table out of three and filter the columns data using another SQL query.

4. If the above filter condition is correct,I will save the column data(of step 1) in an excel.

5. I will have to repeat the process for all the 100 records and save the filtered data in an excel.

I considered it doing with below options but I am stuck and not able to proceed further:

1. Using SSIS

2. Using Nested Cursors

One option of doing that is by creating a user defined function for SP but I cannot do it because the data is in production environment.

Please let me know any process with which I can do it in a simpler manner.

Posted 6-Feb-14 18:24pm

TheFighter

Add a Solution

Comments

Maciej Los 28-Feb-14 16:03pm

Unclear!

V5709 28-Feb-14 23:53pm

Have you tried with nested cursors?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2014-02-28T10:17:00

1. I have list of records(lets say 100) which I did extract using a SQL query from the database.
2. Some specific columns of each record should be given input to a stored procedure. The stored procedure returns three tables as the output.
3. I will have to catch only one of the table out of three and filter the columns data using another SQL query.
I do not understand why do you want to filter only one table from 3 returned by SP.

4. If the above filter condition is correct,I will save the column data(of step 1) in an excel.
5. I will have to repeat the process for all the 100 records and save the filtered data in an excel.
Sorry... Do you know how Structured Query Langage[^] works? There is no need to reapeat ptocess for all 100 records. SQL engine can compare all these 100 records. The result set can be saved to an Excel file.

What i suggest? Start with basics. Here[^] you'll find several tutorials.

For further information, please see:
Tutorial: Writing Transact-SQL Statements[^]
Writing SQL Queries: Let's Start with the Basics[^]
OLE DB Provider for Jet[^]

Please, read above tutorials and come back here with detailed question.
Cheers!