Thanks for the extra information.  I would not have considered using a role if we had AD Groups.  But....I can see where adding that layer would be beneficial.

Thanks!

Found an answer...database roles.  I had been looking at Server roles and those won't work for me. But I can create a role for each database and assign it permissions...

Hi All -
Figured this out finally.  I had to create a Sql Server Credential and Proxy.  I used my account (just to test) as the one for the Credential. ...

Hi...Thanks for the reply and suggestion.

Hi Luis
This seems to work perfectly!  Thank you so much for the help. I didn't even consider a CASE statement...kept thinking about self joins, CTEs, etc.

Thank you...

Hi Jeff -

Thanks very much for the reply and all the options. I will give them a try and see which works best for us. And, yes, we...

Hi Everyone...

Again, thank you for the help and solutions.

I should have mentioned before that the database design/structure is completely and utterly out of my control. Yes, normalization...

Thanks to both of you for the response and solutions. I'll try them out and see how things go.

I appreciate the help

- will