Posted by wxbuff on 10/18/05 23:24

I have a report based on our product names that consists of two parts.
Both insert data into a temporary table.

1. A single grouped set of results based on all products
2. Multiple tables based on individual product names.

I am getting data by calling the same stored procedure multiple
times... for the single set of data I use "product like '%'"

To get the data for individual products, I am using a cursor to parse
the product list.

It's working great except that I have no idea how to identify the
results short of including a column with the product name. While that
is fine, I'm wondering if there is something that is like a header or
title that I could insert prior to generating the data that would look
a little tighter.

Thanks in advance-
Danielle
wxbuff@aol.com

• Next in forum: Re: Identifying results sets when stored procedure called multiple times
• Prev in forum: Re: Unable to update view in Sql Server 2000
• Thread view: Identifying results sets when stored procedure called multiple times

[Reply to this message]