Thanks everyone. All three suggestions were helpful. I was able to get the desired results for my client.

Thank you!!

Thanks again. I may have to go that route.

Thanks for your reply, that was my first thought as well. However, some records in the table doesn't follow the same batchnum format. Therefore, some records would...

OK, Thank you

Mind you, this script will be used in a ETL process that will be run weekly

OK, Thank you. Actually this is in PL/SQL but the process logic should basically be the same.

I have a query as SELECT DISTINCT Field FROM Table a

I...

Thanks to all who has responded. I appreciate your input!!

YEs...Thank you so much for your help!!

Thank you the grouping I refered to happens in the report. The user want to be able to drill into the groups so I have to provide the data...

After running my query to a #temp table I have tried this

DECLARE @Parameter varchar(12)

BEGIN

IF @Parameter = 'Credit'

THEN

(SELECT [Doc Number],[Customer Name],[Owner],[Rev Type1],[Mail Date],[Revenue Date],[Days Outstanding],[0-30 Days],[31-60 Days],

[61-90 Days],[91-120 Days],[121-150 Days],[151...

The issue with this apprach is that the filter is applied on gtoupings. If the net of the grouping is < 0 then is would be returned by selecting...

I need to be able to have a parameter that has two option.

DEBIT = where totals are > 0

CREDIT = where totals are < 0

The user would select one or...

To be more specific, I am talking linked reports using the "jump to" action.

OK..thanks I'll check into that.

OK..thanks