multiple inserts in stored procedure

[Guest_imported]

First of all, I don't know much about sequal server, but I'm investigating the possibilities of converting a mainframe system into a web-application.

I've got the folowing problem:

In one screen I want to display various stocks. I can select them in an other screen one by one, so every time I select a stock, an insert takes place of one stock (the stock is added by a client, done by stored procedure. if I'm not mistaking). After selecting a stock, I will return to previous screen (the display of the vaious stocks).

We also grouped the stocks by segment.

Now I want to select in the select screen one segment. After selecting the segment, all stocks, grouped by that segment, must be displayed in the previous screen. So the stored procedure must insert multiple stocks, one by one.

I've been told that this is not possible. I've not been told why and I can't contact him.
It could be the multiple inserts in the stored procedure. That means that it is not possible to open a table, fetch the records one by one, some moves, insert other records one by one in an different table and close the table. All these actions must take place on one s.p.
Or it could be the select in the previous screen. Normally you insert one record and is added to the previous screen. No extra server IO is necessary (??). Now more than one records are added and it might not possible to show them on the previous screen.

Normally if someone said to me "this is not possible" I would say bullshit, but as I said, I don't know much about sequal server....

So why should someone (experienced programmer) say that this is not possible??

Greetings,

George McGregor
Sr. Application Analist.

 

[rajeevnandanmishra]

Hello George,
If i understood correctly, your major concern is whether "opening a table, fetching the records one by one, some moves, inserting records one by one in a different table and closing the table" is possible in single stored procedure or not.
My vote is with YES. Now if you just give some sample data with table structure (that is going to be used in the procedure) and what result you want (output from the procedure), we can try to help you.