Thank you for using MSDN Newsgroup! It's my pleasure to assist you with
I have studied your code for some time but still confused because so many
information that are not clear in the code. I'd better come back to your
As you mentioned in your first post, you will define a stored procedure,
which will have a result set (someone is eligible for health benefits for a
particular date range), and you want to save it into a workable place.
In your first post, in the stored procedure you defined, you create a table
variable. However, you can create a table variable within a stored
procedure, but not pass it in as a parameter. The output parameters of
stored procedure include include either data (such as an integer or
character value) or a cursor variable (cursors are result sets that can be
retrieved one row at a time). Besides the cursor, you can also return data
as the following way to return multi-row result set. In you case, I suggest
you to save it
in a table. In your stored procedure, you could create a table, then save
the result to this table, then you could work on this table. When finished
using this table, you could drop it. The workload of programming will be
You could refer to the 'Sharing Temp Table' part, especially the last
section of this part
Hope this could help your problem! If you still have questions, please feel
free to post new message here and I am ready to help!
Microsoft Online Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.