l******9 发帖数: 579 | 1 I need to print out a group of values from a procedure on SQL server 2008.
If I use select , it generated a distinct table into the result part of SQL
server 2008 managemetn studio every time the procedure is called.
i need to call the procedure in a loop. I want to print the values into one
table.
Thx!
while
begin
my_procedure()
end
my_procedure()
# do something
select value1, value2, value3
i need to keep the
value1, value2, value3
in one single table after the loop is done.
Currently, everytime my_procedure() is called, a new table is created in SQL
server MS.
I want to keep all of them in one single table. |
|