I have a stored procedure named "sprealdata" which has data of 3 columns and around 50,000 rows
Now I would like to append these data into a table.
I already created a table named "realdata" with three columns. Now I want to append the data from stored procedure to the table using query. Of course I can copy and paste but I don't prefer this.
If it is from another table, I would write like this :
insert into realdata
select * from anothertablename