the subroutine calls the stored procedure, then builds an html representation of an Excel spreadsheet and binds the returned resultset to it.
I did what I wanted to avoid - use a cursor and insert the variables into a table variable. That way I can check the userid for each record returned from the query, then check the awardstatus fields to determine if they need modifying. My version of the stored proc takes about 1 second longer than the original. They'll just have to live with it.
I did what I wanted to avoid - use a cursor and insert the variables into a table variable. That way I can check the userid for each record returned from the query, then check the awardstatus fields to determine if they need modifying. My version of the stored proc takes about 1 second longer than the original. They'll just have to live with it.