Perfect. The only thing I added was the use of Raiserror rather than print.

Thank you so very much!

Thank you much for the reply. I'll give it a try and let you know. (right now the network is down for upgrades so I'm busy waiting:)).

Thanks again,

Di-

Perfect! Not sure why I was being so 'thick'. Seems so simple when someone points it out. Thanks bunches.

Thank you for the quick response. I used the Group By and it works like a charm.

Di-

Here is the code that worked (after I found out all the variables involved - gotta love end users).

select Case incspc.incspc_type

when '10' then 'Product'

when '20' then 'Item'

when '40'...

Thanks guys, a UNION is exactly what I needed.

Diann

sorry about that guys, the actual problem I was having was that - and this is fairly embarressing - on the second union I was joining the wrong column.....:blush:

Thanks for the response Lynn, at the same time I got your response I think I figured out all my issues. Here's what I am using now and it...

OK, I got tied up in another project and am just getting back to this, it works fine if there is only one join I need. Here's a create...

Thanks, now I see - just add the "and incspc_id = 50" to my join. I'll give it a try and see what happens, thanks again - you guys...