How to store a parameterized stored procedure output into another table in SQL Server

Question

I have a stored procedure which takes two parameters (two years) to return all the student information during that period in a school. It returns 3 columns i.e BirthYear, Name, Age. I have to store that procedure's output into another table which is holding the same structure. So the table will hold the structure as

BirthYear Name    Age 
---------------------
1988      Joshep  26
2000      John    17

and so on.

Now my procedure is called getAllInfoOfStudent and it takes two parameters which are any two years, getAllInfoOfStudent (1900, 2018) like that .

So my question is how will I get this done? Please help

Lamak · Accepted Answer · 2018-02-06 19:28:59Z

3

If the table has that same structure, and the sp returns just that data, then you need to use INSERT INTO:

INSERT INTO dbo.YourTable
EXEC getAllInfoOfStudent (1900,2018);

answered Feb 6, 2018 at 19:28

Lamak

70.8k12 gold badges119 silver badges119 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

marc_s · Accepted Answer · 2018-02-06 21:14:49Z

1

You can use the same logic as you would use to insert into a table from a select statement as long as you have our output from your stored procedure formatted correctly to insert into your table.

INSERT INTO YourTableName    
    EXEC getAllInfoOfStudent 1990, 2018

edited Feb 6, 2018 at 21:14

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Feb 6, 2018 at 19:31

VentingOlive

1811 silver badge5 bronze badges

Collectives™ on Stack Overflow

How to store a parameterized stored procedure output into another table in SQL Server

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related