I have a stored procedure which has a number of select and insert statements
in it. It is used to insert records in a number of tables. The last select
statement returns a single row, which I want to use as a kind of returned
parameter. I call this stored procedure from some ASP code using OLE DB, but
this is largely irrelevant I think.
The problem is that the stored procedure seems to return the FIRST select
statements results as it's recordset, not the LAST within the stored
procedure. Is there a way around this? Can you ...